Use $_SESSION within mysql search

[Hyperjase]

Hey all,

 

Trying to search for something within a database, using two different fields, one text box and one drop down (the values are actually table names).

 

Here is what I have, this doesn't work:

<?php
$result = mysql_query("SELECT * FROM cakeorder WHERE `{$_SESSION['name']}` = '".$_SESSION['search']. "'");

 

Thanks!

 

Jason

[PaulRyan]

Try echoing out the $_SESSION variables and the query to make sure they are what you expect.

 

Regards, PaulRyan.

 

[Hyperjase]

My boob, it was outputting correctly, I had the search the wrong way round and needed to change ' for ` on the table name!

 

Thanks,

 

Jason