Error in this line of code !

[june_c21]

Can someone tell me what's wrong with this code .

can't execute , return no result ...

 

$query1 = "Select id,department from event order by id desc";
$result1 = mysql_query($query1,$dblink);
$myrow1 = mysql_fetch_row($result1);
$no = "R0" . $myrow1[0] . " / ";

$department =$myrow1[1] ;

if ($department=='GF1')
{


$query2 = "Select gf1,id from dept_no ";
$result2 = mysql_query($query2,$dblink);
$myrow2 = mysql_fetch_row($result2);
//echo "00"."$myrow2[0]"." / ";
$query3 ="update dept_no set id=id+1, gf1=gf1+1";
$result3 = mysql_query($query3,$dblink);
$no = $no . "GF1 / 0".$myrow2[0]. "/0".$myrow2[1];

}

[PravinS]

Are you getting some error?

[june_c21]

nope, i didn't get any error.....

suppose there will update in the database but the value in the database still remain the same.

[The Little Guy]

try to change:

$query3 ="update dept_no set id=id+1, gf1=gf1+1";

to:

$query3 ="update dept_no set id=(id+1), gf1=(gf1+1)";

 

you may also want to add a WHERE clause...