syntax error

[mymainoffender]

Im full of questions today...

This is what ive got to query:

$sql = "SELECT FROM comments comment,author,date WHERE postnumb=" . $HTTP_GET_VARS['id'];
$result = $connector->query($sql) or die('ERROR: ' . mysql_error());

and im getting this:

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 'FROM comments comment,author,date WHERE postnumb=20' at line 1

[StevenJ]

won't you need

$sql = sprintf("SELECT FROM comments comment,author,date WHERE postnumb=%s" ,  $HTTP_GET_VARS['id'] );

edit: actually, I think what you have anyway, will print exactly the same as what I have done.

try echoing the $sql and then run that at either the SQL prompt or use phpMyAdmin.........

aha...........it's just dawned on me

try

$sql = "SELECT comment,author,date from comments where postnumb=". $HTTP_GET_VARS['id'] ;

try that!