Hello and welcome to our community! Is this your first visit?
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
    Thanked 11 Times in 11 Posts

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

    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 <= 
    HAVING 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

    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 05: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