asked on
$email = $_POST['email'];
$query_Recordset1 = "SELECT customeremail FROM customers";
$Recordset1 = mysql_query($query_Recordset1, $evs) or die(mysql_error());
while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)){;
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
if ( $email == $row_Recordset1['customeremail'] ) {
echo "That email exists";
} else {
echo "That email doesn't exist";
}
}
<?
$email = $_POST['email'];
$query_Recordset1 = "SELECT customeremail FROM customers WHERE customeremail = '".$email."'";
$Recordset1 = mysql_query($query_Recordset1, $evs) or die(mysql_error());
if(mysql_num_rows($Recordset1)){
echo "That email exists";
}else{
echo "That email doesn't exist";
}
?>
echo $email . " " .$row_Recordset1['customeremail'];
ASKER
<?
$email = $_POST['email'];
$query_Recordset1 = "SELECT customeremail FROM customers WHERE customeremail = '".$email."'";
$Recordset1 = mysql_query($query_Recordset1, $evs) or die(mysql_error());
if(mysql_num_rows($Recordset1)){
echo "That email exists";
}else{
echo "That email doesn't exist";
}
?>
ASKER
ASKER
$email = $_POST['email'];
$query_Recordset1 = "SELECT customeremail FROM customers WHERE customeremail='$email'";
$Recordset1 = mysql_query($query_Recordset1, $evs) or die(mysql_error());
if (mysql_num_rows($Recordset1) > 0){
$insertSQL = sprintf("INSERT INTO tokens (email, token) VALUES (%s, %s)",
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['token'], "text"));
mysql_select_db($database_test, $test);
$Result1 = mysql_query($insertSQL, $test) or die(mysql_error());
}
} else {
header( 'Location: doesnt_exist.php' ) ;
}
ASKER
ASKER
ASKER
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
TRUSTED BY
Open in new window
I am just curious as to why you don't check for the email with the query?