> > >       $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

Reply via email to