CODEWITHSUNDEEP
phpmysql
Elitmiar
Elitmiar

Reputation: 36829

How to select data from a table where the table name has blank spaces in?

I have a situation, I have a mySql table named 'Master File' with contains 6000 records.

Howver I get an error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

My code looks as below.

$sql = "SELECT * FROM Master File";
$results = mysql_query($sql);


//Looping threw the Master File
while($row = mysql_fetch_array($results)){
    print_r($row);
}

Upvotes: 4

Views: 5068

Answers (1)

dnagirl
dnagirl

Reputation: 20456

$sql = "SELECT * FROM `Master File`";

You need back ticks around fieldnames that have spaces.

Upvotes: 16

Related Questions