Help again plz!

newbieagain

Hi, I want to ask another few questions. I hope this won't be too stupid.

1) I want to use php to check whether certain values are already in my mysql database. ( checking an email address against my database to find out if it is already there). Would it be able to generate a TRUE/FALSE output?

2)This is similar to the one above: Can I check whether a value in my database is the same as a specified value? (and give a true/false output? (Using this to check whether the user has paid for something or not by checking the database)

I think this is it. Thank you

LordShryku

1) yes
2) yes

newbieagain

can you tell me how to do that?

LordShryku

Best thing to do IMO is to execute a count(*) query where something = 'what you want to check for'. Then when you fecth the row, you'll have a number. 0, it doesn't exist. > 0, it does.

slaya

I dont see much difference between your first question and your second question so this should pretty much cover it all...

$email = 'bob@bobsworld.com';

$query = mysql_query("SELECT email FROM table WHERE email = '$email'");

if (mysql_num_rows($query)  == 0) {
  //if it is not in the db
  echo 'True';
} else {
  //if it doesnt exist in the db
  echo 'False';
}

SlaYa

newbieagain

thank you.