php database.php problems

heya everyone i have a few problems but at the moment il just show the few errors on my homepage that are from database.php

[code]Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in include/database.php on line 380

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in include/database.php on line 381

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /include/database.php on line 383

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /include/database.php on line 402

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /include/database.php on line 404
[/code]

here is my first line that is the main problem which i have changed so many times and it never gets fixed.

[code] /* Calculate number of users at site */
$q = "SELECT * FROM ".TBL_ACTIVE_USERS;

$result = mysql_query($sql,$con);

echo mysql_num_rows($result);

}[/code]

please if anyone can help please please do so.

here is the file incase.
http://www.2shared.com/file/9HjFaj2p/database.html

the query is actually stored in the variable $q, but u r passing $sql as parameter to mysql_query…

send $q as parameter to the mysql_query.

Sponsor our Newsletter | Privacy Policy | Terms of Service