[RESOLVED] Variable in MySQL statement

DJH

I am collecting info from my mysql db, when running

$result = mysql_query("SELECT free from jan where free!=0");

everything is fine but when I replace the table name with a variable

$result = mysql_query('SELECT free from '$_SESSION['table']' where free!=0');

I get

Parse error: parse error, unexpected T_VARIABLE in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Olmeto\Mysql\test.php on line 11

Line 11 is the MySQL statement line.

I have tried adding () and {} .

Is there a way I can use a variable in the statement

Many Thaks in advance.

laserlight

This is less about the SQL statement and more about PHP syntax. Simply put, you have incorrect PHP syntax. It should be:

$result = mysql_query("SELECT free from $_SESSION[table] where free!=0");

or:

$result = mysql_query('SELECT free from ' . $_SESSION['table'] . ' where free!=0');

or some other alternative. You might want to quote the table name as well, in case it contains special characters. By default, MySQL uses backticks (`) to quote identifier names, though the standard is to use double quotes.

Krik

Your quote(') before the $_SESSION['table'] is ending the query string.

Try this

$result = mysql_query("SELECT free from " . $_SESSION['table'] . " where free!=0")

EDIT
guess when its quick reply you can be beaten to the post

DJH

LaserLight and Krik

Many Thanks for your speedy replies.

Cheers

Dave