No Results?

[Anon]

Hey all. I'm going insane over this problem. I can't figure out how to control a statement if no results are returned. ie:

I start a session and set $id to session_id()

function check_session
--connect to db--
$query = "SELECT sessid FROM sessions WHERE sessid = '$id'";
$results = mysql_query($query) or die ("Query Failed");

now here's my problem If no matches were found I want it to call an insert statement, and if it was found load certain data. I can't seem to find a way to figure out if there were results returned or not. isset($results) returns true, trying to return data from it via while($line = mysql_fetch_assoc($results)){
while(list($col_name, $col_value) = each($line)){ echo $col_value;}} returns an error.... I'm completely baffled.

Mark

[johnh]

I hope this helps you, but I found that sometimes the result is true even though its empty. I'm not a master programmer or a guru, but here is what I found to work for me.

$result = mysql_query($query,$link);
if (result) // if true
{
$array = mysql_fetch_array($result);
if ($array) // if true
{
if ($array[used] == "1") // now test for the item.
{
$string = "I found it";
return $string;
}

John

[Anon]

Unfortunately this code doesn't work for me... looks like it would but I get an error

[Anon]

Correction, I figured out the error (forgot to make $link global to this function) but I doesn't allow me to control events. Now when I run it I can get it to perform the function assigned to no results but on reload it continues to think there are no results even though there is now 1 result.

Any ideas?

Mark