hi. Sorry to bother, but i have the same problem, i have changed the name of my database and user to student-radio_r , it has 15 characters, but still nothing. i get the following error :
QUOTE
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'localhost' (using password: NO) in /www/vndv.com/s/t/u/student-radio/htdocs/usersonline.php on line 18
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/vndv.com/s/t/u/student-radio/htdocs/usersonline.php on line 18
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/vndv.com/s/t/u/student-radio/htdocs/usersonline.php on line 19
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'localhost' (using password: NO) in /www/vndv.com/s/t/u/student-radio/htdocs/usersonline.php on line 22
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/vndv.com/s/t/u/student-radio/htdocs/usersonline.php on line 22
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'localhost' (using password: NO) in /www/vndv.com/s/t/u/student-radio/htdocs/usersonline.php on line 32
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/vndv.com/s/t/u/student-radio/htdocs/usersonline.php on line 32
Access denied for user 'vhostswww'@'localhost' (using password: NO)
The php file code is
CODE
<?
//REMEMBER TO CONNECT TO THE DATABASE!!
$ip = $_SERVER['REMOTE_ADDR'];
$time = time();
$ip_check = 'SELECT ip FROM `users_online` WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\'';
$ip_query = mysql_query($ip_check);
$num_rows = mysql_num_rows($ip_query);
if(!$num_rows) { //if no rows, meaning no ip's in db matched theirs, we will add them.
$insert_new = mysql_query("INSERT INTO `users_online` (ip, time) VALUES ('$ip', '$time')");
} //end if NOT THERE
//this means that they're already in there, so we update info.
if($num_rows > 0) {
$update = mysql_query('UPDATE `users_online` SET time=\''.time().'\' WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\'');
if(!$update) die(mysql_error());
} // end UPDATE
//if time now - start time > 300 then its been 5 minutes, so we delete
$delete_old = mysql_query("DELETE FROM `users_online` WHERE ((".time()."-time) > 300)");
if(!$delete_old) die(mysql_error());
//show the number of people online now....
$id_query = @mysql_query("SELECT * FROM `users_online`");
$users_online = mysql_num_rows($id_query);
echo("<BR>The number of people here are : $users_online<BR>");
//users online is done....
?>
It isn't the only application that it is not working, and i have the same error message at anyone of them :|
Thanks