Checking if admin username/email exists

[Phoenix_Down]

Hello, I'm using this code in my add admin function to check if the username and email exists:

        $result = mysql_query("select username from admin where username='$the_username'");
        $query_result_handle = mysql_query($result, $dbi);

    list($usernametocheck) = mysql_fetch_row($result);

    $result = mysql_query("select email from admin where email='$the_email'");
    $query_result_handle = mysql_query($result, $dbi);

    list($emailtocheck) = mysql_fetch_row($result);

    if ($usernametocheck != "") {

    Message("admin.php?op=AdminAdd", "Username Exists", "There appears to be another administrator using that username. Please choose another one.");

    }

    if ($emailtocheck != "") {

    Message("admin.php?op=AdminAdd", "Email Address Exists", "There appears to be another administrator using that email address. Please choose another one.");

    }

I am using the same code for the edit admin function. But, when I edit the username and not the email, it says the email exists, and vice-versa. Please tell me what I'm doing wrong.

Thanks in advance.

[Phoenix_Down]

Can someone please help me? 🙁

[eriksmoen]

try

elseif($emailtocheck !== ""){
//stuff
}

[Phoenix_Down]

No, it didn't work.

[eriksmoen]

got to looking at your mysql code, and was wondering if you could show how its setup... eg

+------------------------+-------------------------------------------+
| Some Name | [e-mail] |
+------------------------+-------------------------------------------+

if thats the case, then it should be

$info = mysql_fetch_array($result);
list($name,$email) = $info[0]; // 0 being the row number.

the way you have it says the dbase structure is

+-----------------------------------+
| Some Name |
| [e-mail] |
+-----------------------------------+

each fetch_row that you perform gets the next row. if you want to restart at the beginning of the array, you will need to add another $result = mysql_query() statment.

hope that helps you out...
sorry for not studying your code last time...

[Phoenix_Down]

I'm sorry, I don't know what you mean in your last post. I'm still somewhat new at PHP and MySQL. My table structure is as follows:

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
  id int(10) NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  password varchar(50) NOT NULL default '',
  email varchar(250) NOT NULL default '',
  lastloggedin varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

Thanks.

[eriksmoen]

$info = mysql_fetch_array($result);
$name = $info[0][username];
$email = $info[0][email];

should work.

in your code, you had $result executed once, and mysql_fetch array was getting info from the first line the first time it was executed and from the second row the second time it executed.

still not sure why you are creating a new table for each new user.

but i hope i made it a little more clear to you. if not, try explaining it a little more detailed so people such as myself can understand... i try helping based on what i THINK you are saying... which may not even be close... nevertheless, hope it helps.