isn't this statement valid?

[adrian_quah]

Isn't this PHP and SQL statement correct:

$q_search = mysql_query("SELECT * FROM $table_name WHERE $search_fields = $search_keywords ORDER BY Customer_ID", $linkID) or die ("Could not retrieve Customer Info");

I used variables inside the query...why cant i retrieve this info?

thanks😃
Adrian

[cgraz]

Unless the field is numeric, use single quotes around $search_keywords

Also, did you check for values on your variables? First things first:

Use or die(mysql_error()) not your own custom messages. You could have done something as simple as forgetting to establish a connection to your mysql server or select a database. Add that then execute the script. See what it says.

If that doesn't solve your problem:

echo "Table: " . $table_name . "<br>\n";
echo "Search Fields: " . $search_fields . "<br>\n";
echo "Search Keywords: " . $search_keywords . "<br>\n";
$q_search = "SELECT * FROM $table_name WHERE $search_fields = '$search_keywords' ORDER BY Customer_ID";
print $query; // print your query to see what it looks like

Print everything to see what it all looks like. Once you get that working right, change your code back. Note that the above code doesn't execute the query, just prints it. Once it prints correctly, you can add in the mysql_query and the mysql_error())

Cgraz