Viewing Thread:
"MySQL/PHP Help.."

I'm having trouble with my Script on F2S, regarding the MySQL. I'm trying to make a Mailing List Add/Delete Script, but the only thing which won't work is the look-up. I need it to look to see if an E-mail Address is already in the Table before it add's or delete's it. The book I'm learning from says I should use this:

$Mail = mysql_query("SELECT Email_Address FROM $Table WHERE Email_Address='$Email_Address'", $Connect);

but that doesn't seem to work, does anyone else know why this may not be working??

Could I ask Freeola what code you use to look-up things, such as a Users Screen name, etc...

Thanx to anyone for their input on this...

i'll give it a go, thank you turbo.

Try using mysql_connect() just as a function, and drop $connect from the end of your script. I know for a fact that works.

Also, don't forget that variables are case-sensitive.

If I were to do what you're doing, I'd do:


funtion conf_mail ($email) {
$qid = mysql_query ("
SELECT * FROM tablename WHERE Email_Address = '$email'
");

return $qid;

};

$mail = conf_mail ($Email_Address);

?>

See if that works.

Maybe I should at that the $Connect at the end of the code came from:

$Connect =
mysql_connect("db.haignet.f2s.com", "username", "password");

I'm having trouble with my Script on F2S, regarding the MySQL. I'm trying to make a Mailing List Add/Delete Script, but the only thing which won't work is the look-up. I need it to look to see if an E-mail Address is already in the Table before it add's or delete's it. The book I'm learning from says I should use this:

$Mail = mysql_query("SELECT Email_Address FROM $Table WHERE Email_Address='$Email_Address'", $Connect);

but that doesn't seem to work, does anyone else know why this may not be working??

Could I ask Freeola what code you use to look-up things, such as a Users Screen name, etc...

Thanx to anyone for their input on this...