[RESOLVED] MySQLi Error **Pulling my hair out** !!!

[chrisguk]

I have this error,

Any ideas before I jump off a bridge lol

Warning: mysqli::prepare() [mysqli.prepare]: (42000/1064): 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 'desc) VALUES (?, ?, ?)' at line 1 in /var/www/test/records.php on line 170
ERROR: Could not prepare SQL statement.

Here is the code:

if ($stmt = $mysqli->prepare("INSERT URL (page, title, desc) VALUES (?, ?, ?)"))
                                {
                                        $stmt->bind_param("ss", $page, $title, $desc);
                                        $stmt->execute();
                                        $stmt->close();
                                }
                                // show an error if the query has an error
                                else
                                {
                                        echo "ERROR: Could not prepare SQL statement.";
                                }

[jeepin81]

You have an error in you SQL INSERT statement.... it should be ' INSERT INTO' not just 'INSERT'.

[chrisguk]

jeepin81;11002602 wrote:

You have an error in you SQL INSERT statement.... it should be ' INSERT INTO' not just 'INSERT'.

Agreed but insert works also and its not causing this error 🙂

[Derokorian]

Also note:

                                        $stmt->bind_param("ss", $page, $title, $desc); 

You have 3 question marks in your query, and 3 variables to be bound, yet you only have 2 s'es this will cause a problem when you fix your query. As for the query itself, have a look at MySQL Reserved Words and you will see that DESC is a reserved word. Either use a different column name OR use backticks ( ` ) to delimit the word as an identifier.

[chrisguk]

@

You are the PHP master. All fixed and thanks 🙂