Re: PHP & MySql

Jonathan, What happens if you take out the comma before the WHERE (as well)? =dn ----- Original Message ----- From: "Paul DuBois" <paul@snake.net> To: "Jonathan Underfoot" <Jonathan@Underfoot.cc>; <php-db@lists.php.net> Sent: 23 November 2001 17:41 Subject: Re: [PHP-DB] PHP & MySql > At 4:16 PM -0700 4/8/01, Jonathan Underfoot wrote: > >I'm getting an Invalid Query error after inputting the following > > > ><connect to Server> > ><select DB> > > > >$sql_query = "UPDATE commentary SET com_num=$com_num, com_by=$com_by, > >com_band=$com_band, com_title=$com_title, com_release=$com_release, > >com_rating=$com_rating, com_body=$com_body, com_type=$com_type, WHERE > >com_num=$com_num"; > >$result = mysql_query ($sql_query) > >or die ("Invalid query / error"); > > > >This is all directly from a form. The variables are all valid. I've tried > >making the query something like > >"UPDATE commentary SET com_release=test WHERE com_num=8" and even that > >dosen't work. > > test is a string and requires quotes around it. Your query is indeed > invalid. > > > > >Ideas? > > > >Thanx, > > > >-Jonathan Underfoot > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >