[RESOLVED] INSERT PROBLEM and SELECT PROBLEM

[zcollvee]

This 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 'by, last) VALUES ('test', '5', '1', '1')' at line 1
This is my code:

$query = "INSERT INTO topics (title, forumid, by, last)
VALUES ('$title', '$forumid', '$userid', '$userid')";

Whats so wrong?

another problem:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /host/z/c/o/zcollvee/viewforum.php on line 10

$query = "SELECT topic_id,title,by,last FROM topics WHERE forumid = '".$forumid."'";
       $result = mysql_query($query);
       while(list($topicid,$title,$by,$last) = mysql_fetch_row($result)){
//etc etc

WHAT IS WRONG?

[laserlight]

My guess is that "by" is interpreted as a keyword, so you must quote it. In the case of MySQL backticks are used as the quotes for identifiers:

$query = "INSERT INTO topics (title, forumid, `by`, last)
VALUES ('$title', '$forumid', '$userid', '$userid')";

The second problem is most likely due to the first.

[zcollvee]

nope.
now it shows this:
MySQL server version for the right syntax to use near ''by',last) VALUES('test','5','1','1')' at line 1

[laserlight]

That does not look right. Did you quote with single quotes or backticks?

[zcollvee]

single

[laserlight]

Use backticks instead. Single quotes are for quoting strings, not identifiers, in SQL.

[zcollvee]

worked🙂