[Resolved] Use of ! before variable if (!$verc) .. WONT WORK!?!?

[m37h0d]

When I enter <URL>?id=blablabhalblah ... its just a white page, but when I enter an ID which is in the database, it does actually work. Why doesnt if (!$verc) work? Thanks.

<?
$id = $_REQUEST['id'];
require("config.php");
 mysql_connect ($hostname, $db_login, $db_pass);
 mysql_select_db($database);

  $select_clan=("SELECT * FROM clans WHERE `clan_id`='$id'");
  $verc=mysql_query($select_clan);

  $clan = mysql_fetch_array ($verc) or die (mysql_error());

  if ($verc)
  {
	 echo "This clan was found in our database.";
}
if (!$verc)
{
	echo "This clan was not found in our database!";
}
?>

[laserlight]

make sure that error_reporting is set to E_ALL and display_errors is On.

You want to know what the errors are, not just get a blank page when something goes wrong.

[m37h0d]

how do you set error_reporting to E_ALL?

[m37h0d]

O nvm I just put

error_reporting(E_ALL);

[devinemke]

if (isset($_REQUEST['id']) && $_REQUEST['id'] != '')
{
	$id = $_REQUEST['id'];
	require('config.php');

mysql_connect ($hostname, $db_login, $db_pass) or exit(mysql_error());
mysql_select_db($database) or exit(mysql_error());

$select_clan = "SELECT * FROM clans WHERE clan_id = '$id'";
$verc = mysql_query($select_clan) or exit(mysql_error());

if (mysql_num_rows($verc)) {echo 'This clan was found in our database.';}
else {echo 'This clan was not found in our database!';}
}
else
{
	echo 'missing or empty id';
}

[m37h0d]

ty very much, but what if i want just clan.php to be a search thing for clans?

EDIT* nvm you have isset in there.

ty it works