Re: suppressing errors
| From: | 1LT John W. Holmes | Date: | Thu, 25 Jul 2002 21:09:59 +0000 |
| Subject: | Re: suppressing errors | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109607@lists.php.net to get a copy of this message | ||
> > > $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" <Preston_Wade@hilton.com>
To: <php-general@lists.php.net>
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" <holmes072000@charter.net>@INTERNET@HHC
> > Sent: Thursday, July 25, 2002 2:53 PM
> > To: Preston Wade; php-general@lists.php.net
> > Subject: Re: [PHP] suppressing errors
> >
> > What is the error you get?
> >
> > ---John Holmes...
> >
> > ----- Original Message -----
> > From: "Preston Wade" <Preston_Wade@hilton.com>
> > To: <php-general@lists.php.net>
> > 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
>