PDA

View Full Version : Lỗi gì ko biết nữa,anh em giúp mình với.



kid_17vn
29-06-2006, 10:37
<?php
foreach ($_REQUEST AS $_arrykey => $_arryval)
{
$$_arrykey = $_REQUEST["$_arrykey"];
}
include "config.inc.php";

mysql_pconnect($db_server,$db_username,$db_passwor d) or die("Unable to connect to server");
mysql_select_db($db_name) or die("Unable to connect to database");

$sessions=$_REQUEST['PHPSESSID'];
$member_name=$_COOKIE['member_name'];
$timexpired = 5;//minutes
$timestamp = time();
$timeout = time()-(60*$timexpired);
if($member_name!=""){
$re_user = mysql_query("select member_name from useronline where member_name = '$member_name'");
if(mysql_num_rows($re_user)>=1){
mysql_query("delete from useronline where member_name = '$member_name'");
mysql_query("INSERT INTO useronline (online_id, member_name, timestamp, ip, sessions, location) VALUES ('','$member_name','$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_REQUEST['PHPSESSID']."','".$_SERVER['REQUEST_URI']."')");
}
}
$result=mysql_query("SELECT * FROM useronline WHERE sessions='$sessions'");
if(mysql_num_rows($result)==0){
mysql_query("INSERT INTO useronline (online_id, member_name, timestamp, ip, sessions, location) VALUES ('','$member_name','$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_REQUEST['PHPSESSID']."','".$_SERVER['REQUEST_URI']."')");
}else{
$result = mysql_query("update useronline set member_name='$member_name', timestamp='$timestamp', location='".$_SERVER['REQUEST_URI']."' where sessions='$sessions'");
}
//delete the values
mysql_query("DELETE FROM useronline WHERE timestamp<$timeout");
?>

Đây là cái functions mình up lên host nhưng nó lại báo lỗi như sau:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.hildeguard/loveyouaiken/iloveyouaiken.net/functions.php on line 24
Failed: Table 'mysql_pconnect.active_users' doesn't exist
Ko biết là lỗi gì mong anh em giúp đỡ nhé.