member reg help code

[mo0ness]

Hi all 🙂

Im making a user registration section to my site..

What I would like to do is after the user inputs a username and the other text fields, the registration process page checks that username isn't already taken? Anyone help me on how to do this? Thanks a lot for your time 🙂.

if ($do_username)
{
// check the username from the database making sure it isnt already in use

// if its already in use..echo an error saying to try another username

// if its not in use..continue with registration..input fields into the table
}
else
{
// echo error saying username field hasnt been filled
}

^ I know what has to be done..I can insert into the databases, do everything, Im just wondering how do I check FROM the database, checking the username input..Any help is appreciated! Thank you 🙂

[drawmack]

<?php
function exists($table,$field,$value,$quoted) {

  $sql = "SELECT count($field) FROM $table WHERE $field="
  $sql .= ($quoted) ? "\"$value\"" : $value;

  $exists = mysql_result(mysql_query($sql),0,0);

  return $exists;
} //end exists
?>