Jump to content

Mysql syntax error


Darkranger85

Recommended Posts

I'm trying to brush up on connecting and interacting with a database and in the tutorial I was directed to write the following:

 


<?php
    //Include Connection//
    require 'connect.inc.php';

    $query = "SELECT 'food', 'calories' FROM 'food' ORDER BY 'id'";
            
    if($query_run = mysql_query($query)){
        echo 'Query was successful!';
    } else {
        echo mysql_error();
    }

?>

 

But, I get the following 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 ''food' ORDER BY 'id'' at line 1"

 

Whereas he gets "Query was successful."

 

I went over mind and compared it to his practically letter by letter and I can't figure it out. Anyone mind pointing me in the right direction? lol

Link to comment
https://forums.phpfreaks.com/topic/255705-mysql-syntax-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.