[SOLVED] How to return a mysql result set

[ryy705]

Hello,

Hello,

mysq_query($query) returns a valid result set. However, calling my custom function query() returns a 1.  For example:

 

<?php
include('connection.php');
$query = "select field from table where field='f1'";
echo mysql_query($query);
echo query($query);

function query($sql) {
   return mysql_query($sql);
}
?>

mysql_query() will echo resouce id #7 and query() will echo 1. I can't Figure out why.  Does any know how to pass a mysql result set?  Many thanks in advance .

 

 

[GingerRobot]

Is that the exact code you are using? Both return a result resource for me.

[ryy705]

Thanks for your reply,

I just changed the name of the field and the name of the table.  Do you suppose it has something to do with the php installation settings?

[ryy705]

Found the problem. I had or die('Query failed. ' . mysql_error()) tacked on the function thats why it wasn't working.  Thanks.