searching for email

[corillo181]

how can i fix this


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@aim.com' at line 1

[fert]

let's see your sql

[corillo181]

[code]<?php
include_once'../includes/db.php';
include_once'../includes/header.php';
$email=$_POST['email'];
$email=stripslashes($email);
$email=mysql_real_escape_string($email);
if($email==""){
echo "please enter your email";
include'../htmlforms/lost_pw.html';
}
$checkemail=mysql_query("SELECT username,password FROM tra_users WHERE email=$email")or die(mysql_error());
while($mail=mysql_fetch_array($checkemail)){
$password=$mail['password'];
$username=$mail['username'];
if(!$checkmail){
echo"that email is not a active email";
include'../htmlforms/lost_pw.html';}else{
$subject=" your lost password";
$message=" hello this is your lost password from mysite.com

username=$username
password=$password

keep your password in a safe place..

This is an automated response, please do not reply!";
mail($_POST['email'],$subject,$message);
echo "your password has been sent";
}
}
?>[/code]

[fert]

try this
[code]
$checkemail=mysql_query("SELECT username,password FROM `tra_users` WHERE `email`='$email'")or die(mysql_error());[/code]

[The Little Guy]

If fert's doesn't work try this:
[CODE]$checkemail=mysql_query("SELECT * FROM `tra_users` WHERE `email`='$email'")or die(mysql_error());[/CODE]

[corillo181]

great!!!! i forgot i had to put '' so query can read the variable..


thanx