Why doesnt this work?

[Anon]

if ($sendpass) {
$query = \\"SELECT * from $table3 where email=$email\\";
$result = mysql_db_query ($db, $query, $link);
$row = mysql_fetch_array($result);
if ($row) {
$mailto = $email;
$mailfrom = \\"From: [e-mail]\\";
$subject = \\"Password for xxx.COM\\";
$body = \\"You have requested your xxx.COM Account password.\\n\\nYour username is $row[userid]\\nYour password is $row[password]\\n\\nYou can log into the xxx.COM registration system at\\nhttp://www.xxx.com/leologin/index.php\\n\\n\\";
mail($mailto,$subject,$body,$mailfrom);
}
}

[sgbalsekar]

i assume that you have established the connection to the database...

the mysql_fetch_array fetches the row into the array, u need to check the count of the array...after fetching the row, u also need to unset the array so as to fetch the next set of rows...

and there are a lot of escape characters () that are not called for...
try and use the following checklist...

1.try running the sql on mysql prompt and check the output...u cud try and optimise it here..
2. check if the php gets the said op as well...
3. display the columns fetched in php...
4. then use the mailto tag...

i hope this solves u r problems...

regs,
sachin balsekar.