hi everyone,
i just want to ask is there any mistake in my code..because whenever i comment the email check it wroks fine but with email check it always gives error that this email already exists.. i am actually checking if the email im going to add is present already or not..

heres my code of action script

<?php include("../includes/config.php");?>
if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db($dbname, $con);

$check= mysql_query("SELECT FROM accounts WHERE (email='".$email."')");
$result = mysql_num_rows($check);
if($result !== 0)
echo header("Location:manage-users.php?status=3");

  $sql=("INSERT INTO accounts VALUES (NULL,'".$email."','".$encpwd."','".$fname."','".$lname."','".$type."','".$recoverykey."','".$image."','".$intro."','".$qualification."')");
  if (!mysql_query($sql,$con))
  die('Error: ' . mysql_error());
  else {



any kind of help will be appreciated :)

$check= mysql_query("SELECT FROM accounts WHERE (email='".$email."')");
Select what from accounts? ALL, Id etc? I guess error checking the query would have given an error.

thanks i got the problem :)