[SOLVED] PHP / MySQL syntax error

[9three]

Hey,

 

I'm pretty sure that my syntax for MySQL is correct, so it could be my PHP syntax that is off.

 

All I'm doing is checking to see if the record of a person already exist. I'm checking by name, email, date, ip, and user agent.

 

    $input = "SELECT
              Name, Email, Date, IP, Agent
              FROM user_input
              WHERE
              Name = '$name', Email = '$email', Date = '$date', IP = '$ip', Agent = '$agent'";
    $check = $connection->query($input);
    if (mysql_num_rows($check) > 1)
      echo 'I\'m sorry you can only post once.';
   else
     //Run code

 

The exception is here:

 

exception 'Exception' with message '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 ' Email = '[email protected]', Date = 'February 15, 2009', IP = '127.0.0.1', A' at line 5' in C:\Users\9three\Desktop\Server\htdocs\gb\library\mysql.class.php:38 Stack trace: #0 C:\Users\9three\Desktop\Server\htdocs\gb\index.php(67): mysql->query('SELECT?? ...') #1 {main} 

[sKunKbad]

Use AND instead of commas in your query (the error is showing you where to start).

[9three]

nvm seems to be working. Looks like I didn't reload the page.