[EMAIL PROTECTED] (Gimic) wrote in
news:[EMAIL PROTECTED]:
> 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.
>
The string $subject is almost certainly empty, as it is not passed as an
argument to the function, nor is it declared global in the function. Try a
little debugging, echoing your query and the output of mysql_error. For
example:
function GetVals() {
$db = mysql_connect("localhost", "root");
$str_Query=("Select * from " . $subject);
mysql_select_db("books",$db);
$result = mysql_query($str_Query);
echo "Query: $str_query<BR>".mysql_error();
echo $result;
}
Then either pass $subject as an argument to the function, or declare it
global within the function.
Lastly, if $string is passed from another script, make sure it is populated
via the GET or POST globals.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
