php function that returns a mysql query

Question

I have a really simple function:

function experience_query($id) {
$sql = @mysql_query(
"
SELECT * FROM table WHERE id = $id
");
return("$sql");
}

When I call this function:

$q = categories_query("1001"); 
while( $list = mysql_fetch_assoc($q) )
{
extract($list);
echo $name;
}

I am getting an error" "mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource..."

Am I allowed to return mysql queries from a function?

Thank you for your help.

possible duplicate of mysql_fetch_array() expects parameter 1 to be resource, boolean given in select — John Conde
– John Conde, Commented Aug 5, 2012 at 21:47

Paolo Bergantino · Accepted Answer · 2009-04-06 19:31:25Z

6

Replace this:

return("$sql");

With this:

return $sql;

By surrounding $sql in quotes you are returning the string representation of the MySQL resource.

answered Apr 6, 2009 at 19:31

Paolo Bergantino

490k83 gold badges523 silver badges437 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1