error in ranking web page

[evilbaz]

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'LoginAttempts'. (severity 16) in C:\xampp\htdocs\config\auth.php on line 48

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\config\auth.php on line 48

Warning: mssql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\config\auth.php on line 49

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'LoginAttempts'. (severity 16) in C:\xampp\htdocs\config\auth.php on line 52

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\config\auth.php on line 52

Warning: mssql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\config\auth.php on line 53




hello all master...
i got this error in ranking web page...
anyone know this problem to teach me how to fix it...

this my php code in auth.php

$IP = $_SERVER['REMOTE_ADDR'];

$select = mssql_query("SELECT * FROM LoginAttempts WHERE IP = '$IP'");
$selectrow = mssql_fetch_array($select);
$LastLogin = $selectrow["IP"];
$Attempts = $selectrow["Attempts"];
$selectdiff = mssql_query("SELECT DATEDIFF(n,LastLogin,getdate()) FROM LoginAttempts WHERE IP = '$IP'");
$selecteddiff = mssql_fetch_array($selectdiff); 

[MentaL]

[jbeitz107]

you are missing the table in you sql server

[A v a r a]

What does line 48 tell?

[Terrified]

Just wanted to ask... do you have an sql table named "LoginAttempts"?

[Ballert123]

Ill take a look