[RESOLVED] SQL Problem

[Semtex_7]

Im having an issue with the MySQL in a program my friend sent me:

The Code:

<?
//if($_SERVER['REMOTE_ADDR'] != "98.226.56.186") {
//exit("<table width=100% height=100%><tr><td align=center><table cellpadding=0 cellspacing=0 style=\"border: solid 1px #000000\" width=200><tr><td bgcolor=#cccccc><font face=verdana><b>Updating</b></font></td></tr><tr><td><font face=verdana>10 min, changing ranks</font></td></tr></td></tr></table>");
//}
session_start();
##############################################################################################
$connection = mysql_connect("host", "username", "password");
mysql_select_db("database", $connection);
##############################################################################################
$newresult = mysql_query("SELECT * FROM `ipban` WHERE `ip` = '".$_SERVER['REMOTE_ADDR']."'");
if(mysql_num_rows($newresult) == 1) {
unset($_SESSION['id']);
header("Location: http://www.google.com");
exit;
}

Thats the bit of code where the error comes from, specificly it comes from Line 11:

if(mysql_num_rows($newresult) == 1) {

When this is on my server I get this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ...

[DexterMorgan]

Hi, is the query working?

try doing:

if(mysql_query("SELECT * ........")){

echo 'works';
}else{
echo 'query failed';
}

BTW should the table name be in single quotes in the query? I have never seen this before, is that not what is giving the error?

EDIT:

Should the field be in single quotes also?

[Semtex_7]

I'm not sure what you mean,
would you mind editing what you mean into the full code I posted in the first post?
Thanks

[DexterMorgan]

<?
//if($_SERVER['REMOTE_ADDR'] != "98.226.56.186") {
//exit("<table width=100% height=100%><tr><td align=center><table cellpadding=0 cellspacing=0 style=\"border: solid 1px #000000\" width=200><tr><td bgcolor=#cccccc><font face=verdana><b>Updating</b></font></td></tr><tr><td><font face=verdana>10 min, changing ranks</font></td></tr></td></tr></table>");
//}
session_start();
##############################################################################################
$connection = mysql_connect("host", "username", "password");
mysql_select_db("database", $connection);
##############################################################################################
if($newresult = mysql_query("SELECT * FROM `ipban` WHERE `ip` = '".$_SERVER['REMOTE_ADDR']."'")){
if(mysql_num_rows($newresult) == 1) {
unset($_SESSION['id']);
header("Location: http://www.google.com");
exit;
}
}else{
die('query failed');
}

If that doesnt work try changing the query to:

mysql_query("SELECT * FROM ipban WHERE ip = '".$_SERVER['REMOTE_ADDR']."'")

[Semtex_7]

When I add the first bit of code you posted, I just get query failed

When I change the query I get: Parse error: syntax error, unexpected T_IF in /home/a7986005/public_html/index.php on line 11

[DexterMorgan]

if($newresult =mysql_query("SELECT * FROM ipban WHERE ip = '".$_SERVER['REMOTE_ADDR']."'") ){ 

Have you changed the IF statement to the code above?

[Semtex_7]

Yup, I just get "query failed'

[DexterMorgan]

<?
//if($_SERVER['REMOTE_ADDR'] != "98.226.56.186") {
//exit("<table width=100% height=100%><tr><td align=center><table cellpadding=0 cellspacing=0 style=\"border: solid 1px #000000\" width=200><tr><td bgcolor=#cccccc><font face=verdana><b>Updating</b></font></td></tr><tr><td><font face=verdana>10 min, changing ranks</font></td></tr></td></tr></table>");
//}
session_start();
##############################################################################################
$connection = mysql_connect("host", "username", "password");
mysql_select_db("database", $connection);
##############################################################################################
if($newresult =mysql_query("SELECT * FROM ipban WHERE ip = '".$_SERVER['REMOTE_ADDR']."'") ){ 
if(mysql_num_rows($newresult) == 1) {
unset($_SESSION['id']);
header("Location: http://www.google.com");
exit;
}
}else{
echo mysql_error();
} 

try that code and paste the results here.

[Semtex_7]

I get:

Table '{database username}.ipban' doesn't exist

[DexterMorgan]

Out of curiousity, how experienced are you with PHP and MYSQL?

$connection = mysql_connect("host", "username", "password");
mysql_select_db("database", $connection); 

I thought you was doing this for security reasons, the stuff in quotation marks needs to be filled in, you will need to sort out the database side of things, all of the PHP looks fine now.

[Semtex_7]

I was doing it for security reasons lol,
I have it filled in on the real server.

[Semtex_7]

Semtex 7;10955233 wrote:

I get:

Table '{database username}.ipban' doesn't exist

Also, Where it says {database username}, It actually says my database username, just to clarify.

[bradgrafelman]

Well is the name of your database the same as your username? If not, there's your problem.

[Semtex_7]

Yeah, they are the same.

[bradgrafelman]

Well I haven't found a SQL server yet that will lie to you, so apparently there is no such table called 'ipban' in your database. Are you positive that name is correct (e.g. using either the CLI or your favorite GUI, you can actually browse the table)? Also note that on Unix-based operating systems (or any other OS's that use case-sensitive file systems), 'ipban' is not the same as 'ipBan'.