Gimic wrote:
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