how to update a field in the db from php

Anon

i have try it already, but it still doesn't work... the database doesn't change... it seems to me that MySQL or PHP doesn't regconise this query...

do you have any idea?

does someone have any suggestion?

Thanks...

ziggs

How to update a mysql entry.
Syntax: "Update dbtable SET field='value1'";
you could also update it by id:: "Update dbtable SET field='value1' WHERE id='1'";
This would update just the entry where id=1. So hope this helps. Of course you could always read the manual at www.php.net and type in Update Statement.
Ziggs

Anon

What query?

ziggs

Yea I asked myself the same question David I just gave the general syntax for it. Its safer that way.
Ziggs

ziggs

Hct. I get what you mean now. FYI ALWAYS post a reply. Do not start another post. We get confused easily. Ok here is your original query: $query = "UPDATE poll SET location = '1,0';";
mysql_query($query);

This is how it should be.
$query = "UPDATE poll SET location='1,0'";
mysql_query($query);

That should do it. If not then you do not have MySQL configured correctly. I took out the extra ;. Cause when mysql got to it, it gets confused and just skips it. So you were telling it to update location to 1,0 end end. It doesnt know what to do with two end statements. So there is the solution to the mystery. 😉
Ziggs

Anon

first of all thanks to all the people who's helping me...

i already try the following code, but it still doesn't want to update the database from phpMyAdmin.

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

i don't know why?

hct