Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    Regular Coder
    Join Date
    Dec 2010
    Location
    London
    Posts
    338
    Thanks
    63
    Thanked 11 Times in 11 Posts

    Question 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.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •