Testing if a result set is empty

[Anon]

I am new to PHP, as I normally develop in ASP. I can connect to a MySQL database and read data from a table with no problems, and echo the results.

What I am trying to do is determine if a UserID exists within the table and if so send the password field as an email, if not then echo an error.

Any help or guidance would be greatly appreciated.

cheers

Graham

[Anon]

Grab the field using your SELECT query.

Use mysql_num_rows() to determine if an entry was returned.

Pull the password and use mail() to send it.

That should work.

[Anon]

But, why do you want to make one connection to ask for the user and another to ask for the mail?
If you want to generate different messages, then you should try making a union in you query, like this:

select user valid_user from table where user=$user
union
select user valid_userpass from table
where user=$user
and pass=$pass

So, you have covered the three posibilities in just one query, much faster.

Hope you've undestood something.