[Delgad0]

Hello. I'm making MySQL register and login system. I made, that, if player is registering he have to enter his email and I don't know how to check, does that email which he entered exists in MySQL database.
Maybe someone can help me?
Thanks!

[Dutheil]

What version of MySQL are you using ?

[Delgad0]

Quote:

Originally Posted by Dutheil What version of MySQL are you using ?

R7

[Dutheil]

Use that function : mysql_num_rows()

[Delgad0]

Quote:

Originally Posted by Dutheil Use that function : mysql_num_rows()

Humm.. But how should I check?

Could you give example? I'll give you +rep

[Vince]

Put a unique key on the e-mail address column. Then just insert. If it comes back with a duplicate key error (catch in OnQueryError) you can just handle it there. Saves you one select query.