update database???

[Anon]

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?

i think php can't regconize the UPDATE query in the mysql_query function.

does any idea that will update the database in phpMyAdmin by using php?

hct

[Anon]

You need a WHERE clause. Something like this.

$query = "UPDATE poll SET location='1,0' where id='$id'";

Also, eliminate the quote before the $query variable.

[Anon]

i have added ask you said, but it still doesn't work... do you have another suggestion?? by the way, thanks for helping...

[Anon]

That is a valid query, there must be some other issue. Can you show me your exact code ? What value are you using as your WHERE criteria ?

Are you properly connected to the DB ?

[Anon]

yes i'm properly connect to the DB... here my code...

---

$mysql[tblpoll] = "pool";
.
.
.
$query = "UPDATE $mysql[tblpoll] SET location='1-1-1-1',speed='0-1' WHERE name = 'survey'";
print "query = $query<br>";
print "update the database<br>";
mysql_query($query);

---

and my DB look like this for now:
table name: pool
name location speed
survey 1-0-1-0 0-0

thanks.

hct

[Anon]

That is a valid query, have you tried it at the command line?

[Anon]

yes i try it... it works... but i don't know why php doesn't want to take it??

[Anon]

Do you establish a proper connection to the correct DB before doing the update ? Are you sure you have a valid connection ? Once again, is your DB connection valid ?

🙂

[Anon]

ok yeah... thanks that is the problem...
thank you very much...

hct