while,foreach and select

[Marco]

Hi there ive trying to make a game based on php and currently ive some
problems with this part of the script, i've tryed to fix it alone with out
success...
This is the script

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "SELECT UserID FROM Star_USER";
$UsersID = mysql_query($sqlUID) or die("Query failed");

while ($UserID = mysql_fetch_array($UsersID,MYSQL_ASSOC)) {
foreach ($UserID as $UID){
$sqlSz = "SELECT Size FROM Star_USER WHERE UserID = '$UID'";
$UserSize = mysql_query($sqlSz);
$OldUS = mysql_fetch_array($UserSize);
$AKA=$OldUS[0]
$UpdateSTR = mysql_query("UPDATE Star_USER SET NW='$AKA' WHERE
UserID='$UID'");
}
}
?>

What i wanted is that each time i run the script it will update the NW field
in the database based on the size of the player and this for each one of
them.
It all works if i take the select statment from inside the foreach, but i
need him there soo i can have the size of the player.
Anyone sees a problem with the script or do i need to find another away to
do it?
Thx

Marco

[Shawn Wilson]

Marco wrote:

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "SELECT UserID FROM Star_USER";
$UsersID = mysql_query($sqlUID) or die("Query failed");

while ($UserID = mysql_fetch_array($UsersID,MYSQL_ASSOC)) {
foreach ($UserID as $UID){
$sqlSz = "SELECT Size FROM Star_USER WHERE UserID = '$UID'";
$UserSize = mysql_query($sqlSz);
$OldUS = mysql_fetch_array($UserSize);
$AKA=$OldUS[0]
$UpdateSTR = mysql_query("UPDATE Star_USER SET NW='$AKA' WHERE
UserID='$UID'");
}
}
?>

What i wanted is that each time i run the script it will update the NW field
in the database based on the size of the player and this for each one of
them.
It all works if i take the select statment from inside the foreach, but i
need him there soo i can have the size of the player.
Anyone sees a problem with the script or do i need to find another away to
do it?

I am not sure of the point of your script. The following should set the field
NW to the value of field Size in each record (I think -- I didn't get much sleep
last night -- be careful).

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "UPDATE Star_USER SET NW = Size";
$UsersID = mysql_query($sqlUID) or die("Query failed");
echo ("<br><br>".mysql_affected_rows()." rows affected.<br><br>");
?>

If you need the size of the player for other uses, you can consolidate your
select statements, instead of using two. This reduces load on the server.

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "SELECT UserID, Size FROM Star_USER";
$UsersID = mysql_query($sqlUID) or die("Query failed");

while ($UserID = mysql_fetch_array($UsersID)) {
//Your game code that uses the player's size goes here
$UpdateSTR = mysql_query("UPDATE Star_USER SET NW='".$UserID['Size']."'
WHERE UserID='".$UserID['UserID']."'");
}

Regards,
Shawn
--
Shawn Wilson
sh***@glassgiant.com
http://www.glassgiant.com

I have a spam filter. Please include "PHP" in the
subject line to ensure I'll get your message.

[Tim Van Wassenhove]

On 2004-01-13, Marco <> wrote:

Hi there ive trying to make a game based on php and currently ive some
problems with this part of the script, i've tryed to fix it alone with out
success...
This is the script

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "SELECT UserID FROM Star_USER";
$UsersID = mysql_query($sqlUID) or die("Query failed");

while ($UserID = mysql_fetch_array($UsersID,MYSQL_ASSOC)) {
foreach ($UserID as $UID){
$sqlSz = "SELECT Size FROM Star_USER WHERE UserID = '$UID'";
$UserSize = mysql_query($sqlSz);
$OldUS = mysql_fetch_array($UserSize);
$AKA=$OldUS[0]
$UpdateSTR = mysql_query("UPDATE Star_USER SET NW='$AKA' WHERE
UserID='$UID'");
}
}
?>

What i wanted is that each time i run the script it will update the NW field
in the database based on the size of the player and this for each one of
them.
It all works if i take the select statment from inside the foreach, but i
need him there soo i can have the size of the player.
Anyone sees a problem with the script or do i need to find another away to
do it?

You already got a got hint on affected_rows etc, but have you ever
thought about what happens when this script is called by 2 users, on
more or less the same time? i'm affraid it might ruin your database.
have a look at lock and unlock or transactions in your mysql manual ;)

--
http://home.mysth.be/~timvw

[Marco]

"Shawn Wilson" <sh***@glassgiant.com> wrote in message
news:40***************@glassgiant.com...

I am not sure of the point of your script. The following should set the field NW to the value of field Size in each record (I think -- I didn't get much sleep last night -- be careful).

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "UPDATE Star_USER SET NW = Size";
$UsersID = mysql_query($sqlUID) or die("Query failed");
echo ("<br><br>".mysql_affected_rows()." rows affected.<br><br>");
?>

If you need the size of the player for other uses, you can consolidate your select statements, instead of using two. This reduces load on the server.

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "SELECT UserID, Size FROM Star_USER";
$UsersID = mysql_query($sqlUID) or die("Query failed");

while ($UserID = mysql_fetch_array($UsersID)) {
//Your game code that uses the player's size goes here
$UpdateSTR = mysql_query("UPDATE Star_USER SET NW='".$UserID['Size']."'
WHERE UserID='".$UserID['UserID']."'");
}

Regards,
Shawn
--
Shawn Wilson
sh***@glassgiant.com
http://www.glassgiant.com

I have a spam filter. Please include "PHP" in the
subject line to ensure I'll get your message.

Indeed your second script is more what im looking for, ill work out the
other issues.

Thx

Marco

[Marco]

"Tim Van Wassenhove" <eu**@pi.be> wrote in message
news:bu************@ID-188825.news.uni-berlin.de...

On 2004-01-13, Marco <> wrote:

Hi there ive trying to make a game based on php and currently ive some
problems with this part of the script, i've tryed to fix it alone with out success...
This is the script

<?php
include("db.php");
include("debug.php");
set_time_limit(0);
dbConnect("sessions");
$sqlUID = "SELECT UserID FROM Star_USER";
$UsersID = mysql_query($sqlUID) or die("Query failed");

while ($UserID = mysql_fetch_array($UsersID,MYSQL_ASSOC)) {
foreach ($UserID as $UID){
$sqlSz = "SELECT Size FROM Star_USER WHERE UserID = '$UID'";
$UserSize = mysql_query($sqlSz);
$OldUS = mysql_fetch_array($UserSize);
$AKA=$OldUS[0]
$UpdateSTR = mysql_query("UPDATE Star_USER SET NW='$AKA' WHERE
UserID='$UID'");
}
}
?>

What i wanted is that each time i run the script it will update the NW field in the database based on the size of the player and this for each one of
them.
It all works if i take the select statment from inside the foreach, but i need him there soo i can have the size of the player.
Anyone sees a problem with the script or do i need to find another away to do it?

You already got a got hint on affected_rows etc, but have you ever
thought about what happens when this script is called by 2 users, on
more or less the same time? i'm affraid it might ruin your database.
have a look at lock and unlock or transactions in your mysql manual ;)

--
http://home.mysth.be/~timvw

Indeed I didn't think about it, this script will only run hourly but Im not
sure what happens if 2 people run it at the same time, probably it wont do
anything good to the DB. Thx for the advice, Im new to PHP (like to all
languages) and I basically learn it step by step when I face a problem.