Susan, try the following: > > $sql = "UPDATE newdacs > > SET emailfwd='$emailfwd', > > mformat='$mformat', > > filter_code='$filter_code'"; // close query string > > if ($FUNC=='USERPOST') { > > $sql. = ",unote='$unote'"; // append additional condition to query > > } > > WHERE user_id='$user_id'"; If I'm reading things properly, it looks like the parser doesn't know that you want to append another condition to the query. Hope this helps. Rich > -----Original Message----- > From: Susan Ator [mailto:SAtor@npr.org] > Sent: Tuesday, June 10, 2003 11:18 AM > To: 'php-db@lists.php.net' > Subject: Is this query even possible? > > > > This is what I am trying to do: > > > > if ($FUNC==("USERPOST") || $FUNC==("MODU")) { > > $sql = "UPDATE newdacs > > SET emailfwd='$emailfwd', > > mformat='$mformat', > > filter_code='$filter_code' > > if ($FUNC=='USERPOST') { > > ,unote='$unote' > > } > > WHERE user_id='$user_id'"; > > $set_newdacs_result = mysql_query($sql) or print > > mysql_error(); > > } > > > > There are several more queries like this which is why I > want to avoid > > duplicating the code since there are only 1 or 2 > differences between them > > depending on function call. > > > > This is the error I am getting: > > > > You have an error in your SQL syntax near 'if > (USERPOST=='USERPOST') > > { ,unote='' } WHERE user_id='2'' at line 5 > > > > Is what I am attempting possible or am I spinning my wheels? > > > > susan > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php