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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php