Toplist ERROR

[Pablo]

hey coders am having a bit a problem with my up coming toplist script i am put a text on the index that shows the amount of site registered this is the code

$sites = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM nt4_toplist"));

echo"<b>$sites[0]</b> Registered Sites!<br/>";

but its not working and am getting this error

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/chill/public_html/gb1/index.php on line 13

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/chill/public_html/gb1/index.php on line 13

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chill/public_html/gb1/index.php on line 13
Registered Sites!


can someone tell me whats the problem?

[ranzit2]

Lol fill password for sql.and username too.

[Pablo]

what do you mean?

[subzero]

He means your a retard. lol

[Pablo]

I know im a retard...

[ranzit2]

PHP MySQL Connect to a Database
connect with database dude.

[Pablo]

?????????????? dude if the data base was not connected the site would not be working

[ranzit2]

?????????????? dude if the data base was not connected the site would not be working

u making me laugh.
Probably u did not included the correct database.php file which has details of database in ur this file where u using this code.
Cant u see the error.?
Read it 5 times.its written using password no.it mean u didnot connected to database.

[subzero]

lol true !

[Pablo]

let me check sumting

[Pablo]

$db_host = "localhost"; // DB Host
$db_user = "chill_pablo"; // DB User
$db_pass = "1234pablopg1234"; // DB Pass
$db_name = "chill_chillblock"; // DB Name
$dbc = mysql_connect($db_host, $db_user, $db_pass);
$dbs = mysql_select_db($db_name);



thats whats in my file!

[subzero]

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'chill_pablo'@'localhost' (using password: YES) in /home/chill/public_html/config.php on line 11


i still see you have not given rights to sql to add/edit/read your toplist!

[GiLL]

$db_host = "localhost"; // DB Host
$db_user = "chill_pablo"; // DB User
$db_pass = "1234pablopg1234"; // DB Pass
$db_name = "chill_chillblock"; // DB Name
$dbc = mysql_connect($db_host, $db_user, $db_pass);
$dbs = mysql_select_db($db_name);



thats whats in my file!

Its seems your using cpanel ok when login in your cpanel click on MySQL® Databases then there you will see

Add Users To Your Databases:

choose your chill_pablo and chill_chillblock

then make sure you tick on Privileges: ALL

then click on add user to database

thats all check now your site

[Pablo]

that was one of the first thing done bro from day one when creating the data base!

[GiLL]

what is your site name ?