Query fails when getting data from MySQL database

Question

I'm trying to get data from an database that I have created in phpMyAdmin. My problem is that however I change my query I'm getting the same type of error message using the mysql_error() function:

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 ''foods'' at line 1

PHP code index file:

<?php
require 'connect.inc.php';

$query = "SELECT 'food_type', 'calories' FROM 'foods'";

if($query_run = mysql_query($query)){

    while ($query_row = mysql_fetch_assoc($query_run)){
        $food = $query_row('food_type');
        $calories = $query_row('calories');

        echo $food.' has '.$calories.' calories ';
    }
}else{
    echo mysql_error();
}
?>

PHP code database connection file:

<?php
$connectionError = 'Can\'t connect.';

$mySqlHost = 'localhost';
$mySqlUser = 'root';
$mySqlPassword = 'Bhu8Nji9';

$mySqlDataBase = 'my_first_database';

if(!@mysql_connect($mySqlHost, $mySqlUser, $mySqlPassword) || !@mysql_select_db($mySqlDataBase)){
    die($connectionError);
}else{
    //echo 'Connected';
}
?>

In your query, swap those apostrophes for backticks. Since none of them are reserved words, you can get away with removing them too. — halfer, Dec 31 '13 at 09:36

score 1 · Answer 1 · answered Dec 31 '13 at 09:36

1

Rewrite your query [Use Backticks instead of Single quotes]

$query = "SELECT 'food_type', 'calories' FROM 'foods'";

to

$query = "SELECT `food_type`, `calories` FROM foods";

answered Dec 31 '13 at 09:36

Shankar Narayana Damodaran

66,874
43
94
124

Or just SELECT food_type, calories FROM foods - and now change your password. – Strawberry Dec 31 '13 at 09:38
@Strawberry, Yes but it is always a good practice to enclose the columns under backticks. – Shankar Narayana Damodaran Dec 31 '13 at 09:39
2

It is good practice, but it's also incredibly irritating IMHO. A better idea is to avoid the use of reserved words. – Strawberry Dec 31 '13 at 09:55
@Strawberry, Exactly. +1 – Shankar Narayana Damodaran Dec 31 '13 at 09:56

GOPI · Answer 2 · 2013-12-31T09:53:55.990

1

use this..

$result = mysql_query("SELECT food_type,calories FROM foods");
while($row = mysql_fetch_array($result))
{...}

edited Dec 31 '13 at 09:53

answered Dec 31 '13 at 09:43

GOPI

1,026
8
30

score 0 · Answer 3 · edited May 23 '17 at 11:49

0

Do not use single quotes around table name and field names.

$query = "SELECT food_type, calories FROM foods";

Also avoid mysql_* functions.

Why shouldn't I use mysql_* functions in PHP?

Read following to know when or why to use backticks

Using backticks around field names

edited May 23 '17 at 11:49

Community

1
1

answered Dec 31 '13 at 09:37

chanchal118

3,339
2
25
50

score 0 · Answer 4 · answered Dec 31 '13 at 09:37

0

Can you try this, added backticks in table foods

$query = "SELECT food_type, calories FROM `foods`";

answered Dec 31 '13 at 09:37

Krish R

22,188
7
49
57

score 0 · Answer 5 · answered Dec 31 '13 at 09:37

0

It is a problem regarding of unknown column name you should use backtick as:

$query = "SELECT `food_type`, `calories` FROM foods";

answered Dec 31 '13 at 09:37

Dinesh

3,886
4
20
33

score 0 · Answer 6 · answered Dec 31 '13 at 09:57

0

There is a syntax error in your query. It should be as below,

$query = "SELECT food_type, calories FROM `foods`";

answered Dec 31 '13 at 09:57

Adarsh Nahar

319
3
10

Query fails when getting data from MySQL database

6 Answers6