check for existing data that matches

[Derokorian]

Hi guys,
I was wondering if it is possible to check for username and email existance in one query but still know which one (or both) was found. Example of two queries below.

<?php
// Input sanitization, connection, etc

// Check for username
$sql = "SELECT * FROM {$dbusers} WHERE admin_user='{$form['username']}'";
$result = $db->query($sql);

// check for email
$sql2 = "SELECT * FROM {$dbusers} WHERE admin_email='{$form['email']}'";
$result2 = $db->query($sql2);

if( $result->num_rows > 0 ) user_error(1051,'That username already exists');
if( $result->num_rows > 0 ) user_error(1052,'That email already exists');

if( !$errors > 0 ) {
   // Insert data
   $sql = "INSERT INTO {$dbusers} (username,email,password) VALUES ('{$form['username']}','{$form['email']}','". saltyhash($form['password'],$mysalt) ."')";
   if( $db->query($sql) ) {
      echo "Successfully added new user: {$form['username']}";
   } else {
      user_error(9070,'Database insertion failed');
   }
}

[dagon]

just use:
WHERE email =BAR OR user =FOO

[Derokorian]

Which would tell me that one of them exists, but not which one. You see the point is I want to know which piece of data already exists.

[dagon]

view the retuned row(s) of the query