PHPNuke SQL Error (installing messenger)
Posted: Thu Apr 10, 2003 5:01 pm
just another php n00b lookin for answers...
im trying to install a instant messenger system for phpnuke. Comes with 2 php files.
BlockMessenger.php in the root phpnuke directory.
and block-messenger.php in ../blocks
here is the error its giving me
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in BlockMessenger.php on line 196
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in BlockMessenger.php on line 198
here are lines 196 and 198
$member_online_num = mysql_num_rows($sql);
while ($session = mysql_fetch_array($sql)) {
and here is where $sql is defined
$sql = mysql_query("SELECT username FROM $prefix"._session." where guest=0");
any ideas?
im trying to install a instant messenger system for phpnuke. Comes with 2 php files.
BlockMessenger.php in the root phpnuke directory.
and block-messenger.php in ../blocks
here is the error its giving me
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in BlockMessenger.php on line 196
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in BlockMessenger.php on line 198
here are lines 196 and 198
$member_online_num = mysql_num_rows($sql);
while ($session = mysql_fetch_array($sql)) {
and here is where $sql is defined
$sql = mysql_query("SELECT username FROM $prefix"._session." where guest=0");
any ideas?