> > > $query = "select user_id from users where username='$username'"; > > > $query_db = @mysql_query($query, $db_connection); > > > $row = @mysql_fetch_array($query_db); > > > if($row) { > > > $message[] = "That username is already taken. Please select > > > another."; > > > } else { > The error is one from mysql stating that I am trying to add a duplicate > entry. I would rather handle this in my code hence the following lines in > my code.
That error message wouldn't come from any of the lines above. You're not INSERTing anything, just SELECTing. Are you sure there isn't another mysql_query() somewhere else without an @ in front of it?? ---John Holmes... ----- Original Message ----- From: "Preston Wade" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 25, 2002 4:58 PM Subject: RE: [PHP] suppressing errors > The error is one from mysql stating that I am trying to add a duplicate > entry. I would rather handle this in my code hence the following lines in > my code. > > if($row) { > $message[] = "That username is already taken. Please select > another."; > } else { > > Thanks for the response. > > Thanks, > Preston > > > > -----Original Message----- > > From: "1LT John W. Holmes" <[EMAIL PROTECTED]>@INTERNET@HHC > > Sent: Thursday, July 25, 2002 2:53 PM > > To: Preston Wade; [EMAIL PROTECTED] > > Subject: Re: [PHP] suppressing errors > > > > What is the error you get? > > > > ---John Holmes... > > > > ----- Original Message ----- > > From: "Preston Wade" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, July 25, 2002 3:20 PM > > Subject: [PHP] suppressing errors > > > > > > > Hello All, > > > > > > I am trying to use the "@" symbol to suppress errors returned by a > > > mysql_query call. This doesn't seem to be working as I get an new page > > with > > > the error in it in my browser. Any help with this would be greatly > > > appreciated. > > > > > > Here is a snippet of the code I am using > > > > > > $query = "select user_id from users where username='$username'"; > > > $query_db = @mysql_query($query, $db_connection); > > > $row = @mysql_fetch_array($query_db); > > > if($row) { > > > $message[] = "That username is already taken. Please select > > > another."; > > > } else { > > > > > > Thanks, > > > Preston > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php