Mysql queries not working inside php functions...

[whitemank]

I'm trying to call a mysql function inside a php function and it is not working. How do I pass a database connection to a function? See the code below that illustrates my problem.

Thanks,
Ken

//PARENT FILE
<?
include '/functions/myfunction.php;

$conn=mysql_connect($db_name, $db_user, $db_password);
mysql_select_db($dbname);
.
.
.
$result=function_call($data1, $data2);

mysql_close($conn);
?>
//END PARENT FILE

//START FUNCTION FILE
function function_call($data1, $data2){
$query=mysql_query("SELECT field FROM table WHERE data='$data1');
$row=mysql_fetch_array($query);
$field=$row['field']; // Field returns empty...
}
//END FUNCTION FILE

[EscapeYourMind]

Try doing

function function_call($data1, $data2){
    $query=mysql_query("SELECT field FROM table WHERE data='$data1'");
    while($row=mysql_fetch_array($query)) {
        $field=$row['field']; // Field returns empty...
    }
} 

[whitemank]

The code itself is fully tested. I got it working in a single file before I split off the functions. The database connection seems to be out of the scope of the function calls. I don't know how to specify to the function which database connection to use.

[Jelena]

Try this

function function_call($data1, $data2){
GLOBAL $conn;
$query = mysql_query("SELECT field FROM table WHERE data='".$data1."'");
$row = mysql_fetch_array($query);
$field = $row['field']; // Field returns empty...
} 

[EscapeYourMind]

and building on what jelena said if you want to put the database connection in there you could also do

$query=mysql_query("SELECT field FROM table WHERE data='$data1'",$conn);

[longneck]

The code itself is fully tested. I got it working in a single file before I split off the functions. The database connection seems to be out of the scope of the function calls. I don't know how to specify to the function which database connection to use.

if fthe cde is fully tested, then why does it have an unmatched double-quote in the mysql_query() line? posting modified or out-of-context code is rarely helpful.

[coo_t2]

If you omit the db connection resource from the mysql_query function it defaults to using the last opened connection.(http://us2.php.net/mysql_query)
But it's good practice to include the db link identifier in the function call so things don't get screwed up later if you decide to open up another connection in your script.
It would also help to know exactly what you want to achieve. What do you want the function return?