Query problem. mysql_error() returns nothing

[nexgen_x]

Having a problem with a MySQL query, and the problem is mysql_error() isn't returning anything. So I don't know whats wrong, other than the fact that $result = false/null...
I've simplified the code down to what is causing the problem (ie this is part of a larger script, but on its own it doesn't work either):

<?
include ("../connect.php");
sql_connect();
sql_accessdb();
$query = "SELECT gid, guildname, guildtype, leader, lemail, repname, repemail FROM guilds";
$result = @mysql_query($query);
if ($result) {
	echo "Database Error: " .mysql_error();
	exit();
}
while ($row = mysql_fetch_array($result)) {
	print $row['guildname'];
}
?>

Can anyone see a problem in any of the above?

Cheers,

[hand]

<?
include ("../connect.php");
sql_connect();
sql_accessdb();
$query = "SELECT gid, guildname, guildtype, leader, lemail, repname, repemail FROM guilds";
$result = mysql_query($query)
	or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";;

while ($row = mysql_fetch_array($result)) {
    print $row['guildname'];
}
?>

[hand]

<?
include ("../connect.php");
sql_connect();
sql_accessdb();
$query = "SELECT gid, guildname, guildtype, leader, lemail, repname, repemail FROM guilds";
$result = mysql_query($query);
if (!$result) {
    echo "Database Error: " .mysql_error();
    exit();
}
while ($row = mysql_fetch_array($result)) {
    print $row['guildname'];
}
?>

[notionlogic]

Like the man said, the problem is in your logic

At the moment your code will report an error IF THE QUERY WORKED but you only want to report a database error if it didn't so add the negation like this

if ( ! $result) {
echo "Database Error: " .mysql_error();
exit();
}

[nexgen_x]

DOH

lol, of all the hundreds of queries I've done, I go and make a dumb mistake like that =/

thanks for waking me up guys 🙂

[jeremuck]

if you use mysql_error() to find if there was a problem, you will never make that mistake

if(mysql_error != "")
{
//error
echo "mysql said: " . mysql_error();
die();
}