MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Trouble with updating Mysql table data
Posted by: Barry Galbraith
Date: March 22, 2012 09:46PM

There is an error on this line 
$sql = "UPDATE library SET title = '" . $Title . "', author = '" . $Author . "', status = '" . $Status . "', WHERE id = $Id ";

Leave out the comma directly before WHERE
That's exactly where the error message is telling you the error is.

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Trouble with updating Mysql table data
Oliver Snyder
March 21, 2012 01:15PM
Re: Trouble with updating Mysql table data
Peter Brawley
March 21, 2012 01:25PM
Re: Trouble with updating Mysql table data
Lanze Langill
March 22, 2012 07:56AM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 08:34AM
Re: Trouble with updating Mysql table data
Lanze Langill
March 22, 2012 10:49AM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 11:14AM
Re: Trouble with updating Mysql table data
Lanze Langill
March 22, 2012 11:20AM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 11:29AM
Re: Trouble with updating Mysql table data
Lanze Langill
March 22, 2012 11:49AM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 11:55AM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 02:44PM
Re: Trouble with updating Mysql table data
Lanze Langill
March 22, 2012 02:55PM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 04:28PM
Re: Trouble with updating Mysql table data
Lanze Langill
March 22, 2012 05:59PM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 07:17PM
Re: Trouble with updating Mysql table data
Lanze Langill
March 22, 2012 07:56PM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 22, 2012 09:03PM
Re: Trouble with updating Mysql table data
Barry Galbraith
March 22, 2012 09:46PM
Re: Trouble with updating Mysql table data
Oliver Snyder
March 23, 2012 04:44AM
Re: Trouble with updating Mysql table data
Rick James
March 24, 2012 09:53PM
Re: Trouble with updating Mysql table data
Barry Galbraith
March 25, 2012 04:11AM
Re: Trouble with updating Mysql table data
Rick James
March 26, 2012 10:58PM
Re: Trouble with updating Mysql table data
Barry Galbraith
March 27, 2012 04:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.