if statmaen in php is not showing correct

Question

the if statement is not showing correct, it is always showing true even is is wrong.

$sql ="SELECT * FROM `namemap` WHERE `info_hash`=='{$_GET['info_hash']}'";
if ( $sql == true )
{errorexit(`error`);
}

Query should be `$sql ="SELECT * FROM namemap WHERE info_hash = '{$_GET['info_hash']}'";` use single = in mysql — devpro, Mar 06 '16 at 21:15
it is same result with ` $sql ="SELECT * FROM namemap WHERE info_hash = '{$_GET['info_hash']}'"; ` — user3657176, Mar 06 '16 at 21:19
`$query = @mysql_query("SELECT * FROM `$db_table`") $sql ="SELECT * FROM namemap WHERE info_hash = '{$_GET['info_hash']}'"; if ( $sql == true ) { errorexit('error'); } ` — user3657176, Mar 06 '16 at 21:25
i have a table named "namemap" with all info_hash and will just allow info_hash who is exit in namemap. do you need see the mysql table for namedmap? — user3657176, Mar 06 '16 at 21:32

score 1 · Accepted Answer · answered Mar 06 '16 at 21:33

1

Your $sql variable is just a string, you never execute a query which I assume you wish to do. A string always evaluates to true.

answered Mar 06 '16 at 21:33

purpleninja

$query = @mysql_query("SELECT info_hash FROM namemap where info_hash = {$_GET['info_hash']}"); $result = @mysql_query($query) or die ("Error in query: $query " . mysql_error()); if (mysql_num_rows($result) > 0 ) { errorexit('error'); } it is still same – user3657176 Mar 06 '16 at 23:04

1 Answers1