Re: Append a Query
| From: | Pete Morganic | Date: | Tue, 22 Apr 2003 11:00:56 +0000 |
| Subject: | Re: Append a Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27251@lists.php.net to get a copy of this message | ||
So close ;-)
Alexa Kirk wrote:
I am trying to make a query based on the user input, for a search page. So, I have the initial query set up like: $query = "select PUB_ID, AUTHOR, TITLE, YEAR from * where
USER.USER_ID=$user and USER.USER_ID=USER_PUB.USER_ID";if ($author != null){
//append this string to the $query already stated
$query .= " and JOURNAL_ARTICLE.AUTHOR=$author";
}
if ($title != null){
//append this string also
$query .= " and JOURNAL_ARTICLE.TITLE=$title";
}
How do you do this concatenation? Thanks, Alexa