[SOLVED] Check value exists in a database

[dont_be_hasty]

Hi,

 

So im creating a webpage using html, php and mysql.

 

I have a form consisting of text boxes in which the user can enter values.

So the user enters a value into the text box, and using php and mysql, the database display info relating this value.

 

Example table:

Table1(id, name, address, email, age).

 

So say the user enters there name, it will display their address, email and age. But say the name doesnt exist in the database table, how do i display an message to say that it doesnt exist.

 

Ive got it so that it will display a message if the text box is not filled in, but not sure how to go about displaying a message if the value does not exist.

 

 

Thanks

[Maq]

You can see if anything was returned with mysql_num_rows().

 

If it's greater than 0 then display the information, else display error message.

[dont_be_hasty]

Thanks, Was able to use mysql_num_rows() to check if anything was being returned and if not it was displaying an error.