Hey y'all, I'm having problems trying to get the MySql_Query() function to return the resource ID when using a $string as the argument to pass to it. It returns when I hard code the argument but not the string. Any ideas? here is what the function looks like:
function GetVals() { $db = mysql_connect("localhost", "root"); $str_Query=("Select * from " . $subject);
mysql_select_db("books",$db);
$result = mysql_query($str_Query); echo $result;
} but when I use the query: $result=mysql_query("Select * from math") it works. Am I setting my string up wrong? Because it's not running into any errors when I do this.
First thing, how would you know if it was returning any errors or not? Try mysql_errno() and mysql_error().
Secondly, I suspect that your "string" is not what you think.
print_r($str_Query); and see what its giving you.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
