0

I'm building a registration script and I want to insert the user's input (username, mail) ONLY if it's not already in the database. What I usually do in such cases is a request to see if something's already there, something like: "SELECT * FROM things WHERE thing_name = '$treated_user_input'".

I have two fields that need to be unique this time though. Is there a way to do only one SELECT request and still be able to tell the user exactly what field went wrong? Or do I have to do one request per unique field?

Thanks for your answers.

1 Answers1

0

Look at SQL distinct for 2 fields in a database for selecting two distinct fields. At that point, if you have at least one result, you can use PHP to determine which is the offending field.

Community
  • 1
  • 1
jbnunn
  • 6,161
  • 4
  • 40
  • 65
  • I don't know why the hell I haven't though about looking at the results of the request. That should do it, thanks. –  Jun 01 '10 at 22:05
  • I'm finding Stack Overflow a lot more helpful than a regular Google search these days – jbnunn Jun 02 '10 at 02:39