if statement in where clause
i'm trying to get my code to find exact matches of 'venuename' only when $searchType = 'venue' and $distance = 0.5, otherwise leave out the constraint.
for the right syntax to use near 'V.venuename = '$venueName' AND V.venuepostcode = P.postcode AND G.price <=' at line 8
I'm guessing it's something to do with the way i'm escaping the $venueName as it works when I simply input 'AND venuename = '$venueName'. ?
Any help would be very much appreciated, I've been stuck on this for a while.
P.S I've just realised this is actually a PHP question and not an SQL problem, if any mods would like to move it!
|All times are GMT +1. The time now is 02:48 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.