[RESOLVED] php + mysql question

[foxter]

Something odd is going on here. The following code does not return $site_id when it should:

			$query = 'select `site_id` from `sites` where `url`='$url'';
			$result = mysql_query($query);
			echo mysql_error();
			$row = mysql_fetch_row($result);
			if ($site_id != "")
				siteScreen($site_id, $message);
			else
				showsites($message);

I excute the same query from PhpMyAdmin, and it works fine:

select `site_id` from `sites` where `url`='http://www.yahoo.com/'

If its incorrect, then how do I get the $site_id based on a given $url string?

print $result;

... prints: Resource id #11

[penagate]

None of the mysql_* functions automatically populate variables for you. You access fields returned in a dataset by using the index notation, either by numerical index, or, if you use mysql_fetch_assoc(), the field name.

Also, you should check whether you need to call mysql_error() or not.

$result = mysql_query('select `site_id` from `sites` where `url`='$url'');
if (!is_resource($result)) echo mysql_error();

if (mysql_num_rows($result) > 0) {
  $row = mysql_fetch_assoc($result);
  if ($row['site_id'] != '')
    siteScreen($site_id, $message);
  else
    showsites($message);
}
else {
  // Not found, place handler code here
} 

[foxter]

Doesnt work either

$result = mysql_query('select `site_id` from `sites` where `url`=\'$url\''); 
if (!is_resource($result)) { echo mysql_error(); }
if (mysql_num_rows($result) > 0) {
    $row = mysql_fetch_assoc($result);
    if ($row['site_id'] != '') {
        siteScreen($row['site_id'], $message);
        }
    else {
        showsites($message);
        }
    }
else { 
    showsites($message);
    }
print "<hr>".$row['site_id']; 

[penagate]

What happens then?

Also, on an unrelated note, don't use print or echo to output HTML code, unless it's just for debugging. There's no point otherwise.

[john tindell]

Have you tried using print_r to display the array of results that is being returned from your query?

[foxter]

print "<hr>";
print_r ($row);
print "<hr>";
print_r ($result); 

$row does not print anything.
$result prints Resource id #11

What could that be?

[foxter]

Thanks guys, I got this working:

            $result = mysql_query("select site_ID from sites where url='$url'");
            echo mysql_error();
            $row = mysql_fetch_row($result);
            $site_id = $row[0];

            print "<hr>".$site_id;