RE: [PHP-DB] problem with mysql_error()

<br>Error Message: " . @mysql_error the '@' symbol suppresses the error message...remove it bastien

From: Jason Gerfen <jason.gerfen@scl.utah.edu> To: php-db@lists.php.net Subject: [PHP-DB] problem with mysql_error() Date: Thu, 27 Oct 2005 08:43:13 -0600 I am not sure why this is not returning any values but it should be. The database structure CREATE TABLE hosts ( id int(11) NOT NULL auto_increment, hostname varchar(100) NOT NULL default '', mac varchar(100) NOT NULL default '', ip varchar(100) NOT NULL default '', vlan varchar(100) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY mac (mac), UNIQUE KEY ip (ip), UNIQUE KEY hostname (hostname), UNIQUE KEY id (id) ) TYPE=MyISAM AUTO_INCREMENT=4705 ; And the code: $update = @mysql_query( "UPDATE hosts SET hostname=\"$host\", mac=\"$mac\", ip=\"$ip\", vlan=\"$vlan\" WHERE id=\"$id\"", $db )or die( "<img src=\"images/error.jpg\">&nbsp;&nbsp;<b>Error: </b>Problem occured while updating host records for $host.</b><br>Error Message: " . @mysql_error( $update ) . "<br>" . "Error Number: " . @mysql_errno( $update ) . "<br>Email Administrator: <a href=\"mailto:$defined[mail]\">$defined[mail]</a>" ); Because I have set a couple of the fields to unique I should be recieving an error of 'duplicate entry' but i am getting an empty result for mysql_error(). Any help is appreciated. -- Jason Gerfen Student Computing Labs, University Of Utah jason.gerfen@scl.utah.edu J. Willard Marriott Library 295 S 1500 E, Salt Lake City, UT 84112-0860 801-585-9810 "My girlfriend threated to leave me if I went boarding... I will miss her." ~ DIATRIBE aka FBITKK -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php