Authenticate.php SQL Error help

[DesignLoft]

For some strange reason when i go to login, the URL in Mozilla changes to ....Authenticate.php with a blank screen. So i check my error logs to see what is the problem and this is it

"

PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/home/ben/public_html/mafia/authenticate.php on line 30

"

line 30 is

"

$uq=mysql_query("SELECT userid FROM users WHERE login_name='{$_POST['username']}' AND `userpass`=md5('{$_POST['password']}')",$c) or die(mysql_error());

 

I have deleted all the tables,re-uploaded the game files and yet still the same error? any help please

[Decepti0n]

Re: Authenticate.php SQL Error help

try deleting the ,$c on line 30, its not needed anyway and thats what the error is from what i remember

not sure if thats why it comes up blank though, might be something else, see if anything changes if you delete that bit

[DesignLoft]

Re: Authenticate.php SQL Error help

its okay now! Just suddenly decided to start working.. :?

[webster2001]

Re: Authenticate.php SQL Error help

i have got exactly the same problem but it comes up showing the code i have put in.

Anybody help? :|