Update query (mysql)

Expand Post »

Good day members!

Could somebody help me here, could modify it for me. There is an error in the syntax:

$query = "UPDATE jobs SET position = '$position1', description = '$description1' WHERE id = '$checkbox1'";
$query = $query . " 'UPDATE jobs SET position = '$position2', description = '$description2' WHERE id = '$checkbox2'";
$query = $query . " 'UPDATE jobs SET position = '$position3', description = '$description3' WHERE id = '$checkbox3'";

Thanks in advance....

Roland

Similar Threads

Please help with JSP mysql update query in JSP
How can i update a query that have more than 3 tables using adodc in vb? in Visual Basic 4 / 5 / 6
UPDATE query not working properly... in PHP
Need update query--Remove the coma "," in PHP
Error while trying the update query in ASP

rcasinillo_s

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Jan 2006

Permalink

Jan 24th, 2006

Re: Update query (mysql)

hi,

i haven't try out on a actual database yet, but maybe it could be due to the'$variable', u can try to remove the ' ' ,hope it helps, if its not working, can u let me know the error message??

tris

tristan17

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

51 posts
since Sep 2005

Permalink

Jan 24th, 2006

Re: Update query (mysql)

I'd say it's because MySQL will only accept one database command at a time. When you put the full string into phpMyAdmin it's code will break it up into 3 update commands and send them down. You have to do this yourself.

sarahk

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

138 posts
since Apr 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: error parsing php code

Next Thread in PHP Forum Timeline: Sessions...help me please

DaniWeb Message

Cancel Changes

User Name
Password