how to update the database from php??

Hello...

PLEASE HELP ME!!

can we update a database in MySQL from a php program...

i did the follow code but it doesn't work...

let's say:
my table call poll,
my field call location. it has 0,0 for the data

and i want to update it to 1,0

i have already connect the database from the php. and i put the following code...

$query = "UPDATE poll SET location = '1,0';";
mysql_query($query);

this code doesn't work don't know why... but i try the same query in the database from MySQL. it works...

did i do something wrong??
can i update a field of the MySQL database from php??

Thank You.

yes, change it so it is updating a specific row in the db.

$query = "UPDATE poll SET location = '1,0' where ID = '$ID' ";
mysql_query($query);

Thanks!!

but i only have one row in the database...

do i really need that? but i gonna try you suggestion. Thanks again...