Wierd problem (to me that is)

Anon

Okey, this is really giving me a headache!
You are the true wizards so help me please.

This works fine.

mysql_connect ($host, $username, $password) OR DIE ("Could not connect to MySQL");
mysql_select_db($database) OR DIE ("Can't select database.");

This too...

$count_users = mysql_query("SELECT count(*) FROM $table WHERE time>$nu AND day=$dag");
echo (mysql_result($count_users,0));

But this doesn't...It's the same, just another query.

$sidcheck = mysql_query("SELECT count(*) FROM $table WHERE SID=$SID");
echo (mysql_result($sid_check,0));

For this I get the error:
"Supplied argument is not a valid MySQL result resource"

But why does the first one work and NOT the second one...
Please help!!

Thanx!

Anon

Looks to me to be a case of either an extra or missing underscore. You are assigning the result set to $sidcheck (no underscore), but checking for results in $sid_check (with underscore). Changing one or the other should solve the problem.

Anon

Also, is column SID text or numeric? If the former, you need single quotes around it, i.e.

  "SELECT count(*) FROM $table WHERE SID='$SID'"

Anon

Thank you guys! I didn't realize that text or numeric made a difference.
It was that the problem was.

This is what I was working on,
a counter for currently online users...

http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=134