Warning: mysql_num_rows(): supplied argument is not a valid MySQL result..

[Drominus]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 14.

 

<?PHP

require_once("dbcheck.php");

require_once("check.php");

$Username=$_COOKIE['Username'];

$Password=$_COOKIE['Password'];

$Nickname=$_COOKIE['Nickname'];

$Username=mysql_real_escape_string($Username);

$Password=mysql_real_escape_string($Password);

 

date_default_timezone_set('Asia/Calcutta');

 

$action = $_GET['do'];

$Result=mysql_query("SELECT * FROM Checks WHERE UserName='$Username'");

$Rowexist=mysql_num_rows($Result);

if($Rowexist!=0){

while($Rows=mysql_fetch_array($Result))

{

$Serial = $Rows['Serial'];

$Banned = $Rows['Banned'];

$IP = $Rows['IP'];

$Used = $Rows['Used'];

$First = $Rows['First'];

$Duration = $Rows['Duration'];

$Total = $Rows['Total'];

$Time = $Rows['Time'];

}

if($action=="" || $action=="Banlist"){

mysql_query("UPDATE Checks SET NickName='$Nickname' WHERE UserName='$Username'");

?>

[Pikachu2000]

Your query is failing. mysql_error should help you figure out why. It would also be helpful to echo the query string to make sure it contains the values you'd expect it to contain.

[Drominus]

I actually cant understand what youre meaning.. Is there any ways you could make a preview

[melloorr]

I actually cant understand what youre meaning.. Is there any ways you could make a preview

 

$Result = "SELECT * FROM Checks WHERE UserName='$Username'";
$Rowexist = mysql_query($Result);

[Drominus]

Now its a blank page.

[melloorr]

Now its a blank page.

 

$Result = "SELECT * FROM Checks WHERE UserName='$Username'";
$queryresult = mysql_query($Result) or die(mysql_error());
$Rowexist=mysql_num_rows($queryresult);

[Drominus]

Table '******_forum.Checks' doesn't exist

[melloorr]

Table '******_forum.Checks' doesn't exist

Thats pretty much self explanatory. The table Checks doesn't exist. Have you checked the database and made sure it does exist? Actually, have you connected to the database?

[Drominus]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/elitehax/public_html/GuidTech/members.php on line 17

 

 

*I added the Checks table.

[melloorr]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/elitehax/public_html/GuidTech/members.php on line 17

 

 

*I added the Checks table.

 

Because it would not be $Result, it would be $queryresult.