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

mysql, php

Solution

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

You need back ticks around fieldnames that have spaces.

Problem

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); } ```

Original source