Re: php - mysql query issue
| From: | Richard Lynch | Date: | Fri, 15 Sep 2006 16:40:42 +0000 |
| Subject: | Re: php - mysql query issue | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-241830@lists.php.net to get a copy of this message | ||
On Fri, September 15, 2006 7:35 am, Dave Goodchild wrote:
> Hi all. I am building an online events listing and when I run the
> following
> query I get the expected result set:
> Any ideas why not? I know it's more of a mySQL question so apologies
> in
> advance!
Well, you'd have to tell us what's in $start_string.
Otherwise, we are just making wild guesses with nothing to back them up.
And, really, to be 100% certain, you'd want to echo out the query
you've built after $start_string is interpolated.
$query = "SELECT ... '$start_string' ...";
echo $query, "<hr />\n";
mysql_query($query, $connection);
After you've done that, it's dollars to donuts that you won't need us
to answer the question. :-)
--
Like Music?
http://l-i-e.com/artists.htm