I'm trying to write a "send password" code to email. But something's wrong in the sql that it leaves the page blank:
http://www.gbgrafix.com/sendpassword.rarPHP Code:<?php
$time = set_time_limit(30);
include("includefiles/dbconnection.php");
$sql = "SELECT * FROM ".$dbTable." WHERE email='".$_GET['youremail']."'";
echo $sql;
$result = mysql_query($sql) OR exit( 'Error: ' . mysql_error() );
while($row = mysql_fetch_array($result)){
$ID[] = $row["ID"];
$username[] = $row["username"];
$password[] = md5_file($row["password"]);
$program[] = $row["program"];
$fname[] = $row["fname"];
$lname[] = $row["lname"];
$email[] = $row["email"];
echo $password[0];
}else{
echo "Your email cannot be found!";
}
mysql_close($con);
$my_email = $_GET['youremail'];
$continue = "/thewheelofgod/twotexts/";
$errors = array();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php echo "<meta http-equiv='Refresh' content='".$time."; url=".$continue."' />";
//echo $time;
?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Inserting The Data In The Tables</title>
</head>
<body>
</body>
</html>
The one with no sql works fine.




Reply With Quote