while loop

[skyloon]

this can be done when only one record in the table, if more than one record in the table, it show the error message.
Warning: Supplied argument is not a valid MySQL result resource in c:\phpweb/test5.php on line 6
how can i change this code to select the first row first, run the script, and then select the second row, run the scriptand so on.
then update the the different result in different rows.

+-------+------+------+
| User | Year | Days |
+-------+------+------+
| Ken | 2002 | 5 |
| Peter | 2003 | 9 |
+-------+------+------+

<?
$query = "SELECT Year, Days FROM user"; 
$result = mysql_query($query); 
while($row = mysql_fetch_array($result)) 
{
  $CurrentYear = date("Y");
  $Diff = $CurrentYear - $Year;
  $Year = $row['Year'];
  $Days = $row['Days'];
    if ($Diff <= 2){
	$Year = $Year + 1;
	$result = mysql_query("UPDATE user SET Year=$Year");
  }

.
.
.
.
.
}
?>

[bad76]

Hi,
after a mysql_query() insert this, and this tell you the error:

mysql_query($query) or die(mysql_error().":<br>".$query);

And next time make a question, please...

see you

[drawmack]

well I can tell you one problem. This is going to update every row in the table, use a promary key and a where clause on the update to avoid this.

As for your error try quoting year and see what happens.

[skyloon]

i use this

mysql_query($query) or die(mysql_error().":<br>".$query);

but it still show this
Warning: Supplied argument is not a valid MySQL result resource in c:\phpweb/test5.php on line 6

i need to update all rows in the same time

[bad76]

Originally posted by skyloon
i use this but it still show this
Warning: Supplied argument is not a valid MySQL result resource in c:\phpweb/test5.php on line 6

My bad, sorry. (and two this day...)
just change the second $result. Use $result2 instead...

$result2="update...

using or die(mysql_error()) is a good hint however...

[skyloon]

if i remove the $result, it can update the table, but with the same $Year in 2 rows

[bad76]

$query = "SELECT Year, Days FROM user";  

$result = mysql_query($query);  

while($row = mysql_fetch_array($result))  

{ 
  $CurrentYear = date("Y"); 
  $Diff = $CurrentYear - $Year; 
  $Year = $row['Year']; 
  $Days = $row['Days']; 
    if ($Diff <= 2){ 
    $Year = $Year + 1; 
  //here if you use $result again at next loop you'll get error
  //because overwrite the previous...
  //use $result2 instead...
    $result2 = mysql_query("UPDATE user SET Year=$Year"); 

[skyloon]

i've tried, but the same problem arised.

<?
$Connect = mysql_connect("localhost","root","");
mysql_select_db("mw");
$query = "SELECT Entitlement, YearStarted FROM user"; 
$result = mysql_query($query); 
while($row = mysql_fetch_array($result))
{
	$YearStarted = $row['YearStarted'];
	$Entitlement = $row['Entitlement'];
	$CurrentYear = date("Y");
	$YearsWorked = $CurrentYear - $YearStarted;
	if ($YearsWorked <= 2) {
		if ($Entitlement >= 10){
		$CarryForward = 10;
		$Entitlement = $CarryForward + 18;
		$result1=mysql_query("UPDATE user SET Entitlement=$Entitlement") or die(mysql_error().":<br>".$query);
		}
		else {
		$Entitlement = $Entitlement + 18;
		$result1=mysql_query("UPDATE user SET Entitlement=$Entitlement") or die(mysql_error().":<br>".$query);
		}
		}
	else {
		if ($Entitlement >= 10){
		$CarryForward = 10;
		$Entitlement = $CarryForward + 19;
		$result1=mysql_query("UPDATE user SET Entitlement=$Entitlement") or die(mysql_error().":<br>".$query);
		}
		else {
		$Entitlement = $Entitlement + 19;
		$result1=mysql_query("UPDATE user SET Entitlement=$Entitlement") or die(mysql_error().":<br>".$query);
		}
	}
}	
?>

[skyloon]

i want it check each row and update each row
i have a table:

+--------+------------+-----------+
| StaffID | YearStarted | Entitlement |
+--------+------------+-----------+
| Ken | 2003 | 7 |
| Peter | 2002 | 17 |
+--------+------------+-----------+

when i run the script, it suppose to show this:

+--------+------------+-----------+
| StaffID | YearStarted | Entitlement |
+--------+------------+-----------+
| Ken | 2003 | 25 |
| Peter | 2002 | 28 |
+--------+------------+-----------+

but it show this:????

+--------+------------+-----------+
| StaffID | YearStarted | Entitlement |
+--------+------------+-----------+
| Ken | 2003 | 28 |
| Peter | 2002 | 28 |
+--------+------------+-----------+