CodingForums.com - View Single Post

paddyfields · 11-27-2012, 05:36 PM

Hello.

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.

code snippet

PHP Code:


			
$sql = "



FROM gig AS G, venue AS V, postcodes AS P

WHERE gigdate BETWEEN '$dStart' AND '$dEnd'

AND G.venueid = V.venueid

" . ($searchType == 'venue' && $distance == 0.5 ? 'AND V.venuename = \'$venueName\'' : '' ). "

AND V.venuepostcode = P.postcode

AND G.price <= $searchPrice

HAVING distance<=$distance



";

The error I'm getting is this...
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.

Many thanks
Patrick.

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!

11-27-2012, 05:36 PM	PM User \| #1
paddyfields Regular Coder Join Date: Dec 2010 Location: London Posts: 283 Thanks: 60 Thanked 11 Times in 11 Posts	if statement in where clause Hello. 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. code snippet PHP Code: `$sql = " FROM gig AS G, venue AS V, postcodes AS P WHERE gigdate BETWEEN '$dStart' AND '$dEnd' AND G.venueid = V.venueid " . ($searchType == 'venue' && $distance == 0.5 ? 'AND V.venuename = \'$venueName\'' : '' ). " AND V.venuepostcode = P.postcode AND G.price <= $searchPrice HAVING distance<=$distance ";` The error I'm getting is this... 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. Many thanks Patrick. 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! Last edited by paddyfields; 11-28-2012 at 04:31 PM..