Simple problem, but I'm stumped...

jkurrle

I have a database script that is supposed to access a MySQL table and return a (1 | 0) value. Instead of getting data, I'm getting the Resource ID number of the column. Here's what I have:

<?php

function checkid($id,$directory)
{

$connection = mysql_connect("myserver.webaddress.com","user_id","access_pw")
or die ("Could not connect to database server");

$db = mysql_select_db("security",$connection)
or die ("Could not connect to database");

$query = "select $directory from directories where access_id='$id' ";

$result = mysql_query($query)
or die ("Query had errors");

mysql_close($connection);

return $result;
}

$value = checkid(user1,dir_name);
echo $value;

?>

When I look at the result on the screen, instead of seeing a 1 or a 0, I see "Resource id #3".

Do I need to feed my results into an array and read it from there, or is there a simple fix to my code? Any assistance would be appreciated...

John K

devinemke

your function simply returns the recordset, you then need to use various function to iterate thru that recordset. if you are only expecting one row to be returned from your query (that is to say if access_id is a unique field) then you could do:

$value = checkid(user1, dir_name);
echo mysql_result($value, 0);

or if you expected several rows then...

$value = checkid(user1, dir_name);
while ($row = mysql_fetch_array($value))
{
echo $row[0] . '<br>';
}

you might want to think about having your function return an array of the recordset data rather than the recordset itself, might save you extra code everytime you call the function.

jkurrle

I ended up modifying my code thus:

=====
<?php
function checkid($id,$directory)
{

$connection = mysql_connect("myserver.website.com","user_id","access_id")
or die ("Could not connect to database server");

$db = mysql_select_db("security",$connection)
or die ("Could not connect to database");

$query = "select $directory from directories where access_id='$id' ";

$result = mysql_query($query)
or die ("Query had errors");

$row = mysql_fetch_array($result,MYSQL_ASSOC);

$yes_or_no = $row[$directory];

mysql_close($connection);

return $yes_or_no;

}

?>

This function appears to work as expected. Thanks for your assistance!