help me. mysql update problem!

[flashmonkey]

Hi Fellows!

mysql update via form is not working. Here is the code:

 

_{$id=$_GET['id'];}

_{if(isset($_POST['now']) && !empty($_POST['update'])){}

_{$update=$_POST['update'];}

_{$query="UPDATE achv_tbl SET achv_desc='$update' WHERE achv_id='$id';";}

_{$result=mysql_query($query)or die(mysql_error());}

 

I have granted all priviledges to the username. I am using mysql version 5.0.45. I have also tried copying the update sql code from phpmyadmin but still it is not working. Any help/suggestions will be highly appreciated. Thankz in advance!

 

EDIT:

Changed subject to conform to forum policy.

 

[thebadbad]

I think you have an extra semicolon at the end of the query. It should end achv_id='$id'";, I'm pretty sure.

 

Well, I was wrong apparently. But remember to escape what's sent with the query with mysql_real_escape_string(), to avoid SQL injections.

[revraz]

What is the error?

 

Echo the $query to make sure it looks ok, maybe a variable is blank.

 

And the semi colon is fine at the end.

[flashmonkey]

No error appears on the _{mysql_error();}. I have debugged the entire page multiple times and everything outputs correctly when i use _{echo "";}. Entry/delete forms are working smoothly. I have also tried removing the extra _; but it still doesn't work. :'(

[Barand]

Are you sure $id has a value (you use $_GET for that one)

[flashmonkey]

;D Solved the problem! Just removed the quotes from $id and the thing is working. Thankz to all who replied. Really appreciate it. ;D