1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

SQL syntax error

Discussion in 'PHP' started by MrPJH, Dec 5, 2011.

0
  1. #1
    Where and what is the error ?

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select column from this_table where email=example@example.com limit 0, 10' at line 1

    
$hid="select column from this_table where email=".$_SESSION['email'];
$hid2="select * from that_table where status1=1 and status2=1 and status1<>3 and id not in $hid limit $start, $max";
    PHP:
    in status1<>3 i used both
    status1<>3
status1!=3
    PHP:
    but no luck
    $start, $max defined to use limit on result display on a page

    any help
     
    MrPJH, Dec 5, 2011 IP
  2. mfscripts

    mfscripts Banned

    Messages:
    319
    Likes Received:
    4
    Best Answers:
    8
    Trophy Points:
    90
    Digital Goods:
    3
    #2
    select column from this_table where email=example@example.com limit 0, 10;

    Add single quotes around the email value:

    select column from this_table where email='example@example.com' limit 0, 10;
     
    mfscripts, Dec 6, 2011 IP