RE: Is this query even possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux