[Resolved] check if record exists and display message

[da_marek]

i have simple table with e-mails only. i want to check if an e-mail exists or not and display message after that...

<? if ($submit_email != '') {
$sql_newsletter = mysql_query("SELECT * FROM newsletter");

//  here i have to check if there is same e-mail in the table and if is then display

echo "user exists";

// or if not then display

else {
echo "thanks";
}
}

[leatherback]

use something like:

$query ="select * from newsletter where email=$email";

if (mysql_num_rows($query) >0)
  {
  echo "User exists";
  }
  else
  {
  echo "You have just won the lottery!!";
  }

echo "Hope this helps!?";

[da_marek]

yes this helps a lot! but instead of

$query ="select * from newsletter where email=$email";

must be

$query ="select * from newsletter where email='$email'";

thanks again!