PHP Emailing List Warning

[tebrown]

Was just following a tutorial on youtube for creating a mailing list. Ideally i want to send an email to everyone in my team using a form.

 

I copied the php code exactly, but im getting the error of:

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in...

 

<?

 

 

$get = mysql_query("SELECT * FROM email WHERE club = 'Inglewood' team = 'Senior As'");

 

while ($getrow = mysql_fetch_assoc($get))

{

echo $getrow['email'];

 

}

 

?>

 

Any help much appreciated.

[Pikachu2000]

Missing an AND between the two WHERE comparisons.

[tebrown]

Thanks, although im still getting the error after i changed that:

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in

 

 

<?

$subject = mysql_real_escape_string($_REQUEST['subject']);
$message = mysql_real_escape_string($_REQUEST['message']);

$get = mysql_query("SELECT * FROM email WHERE club = 'Inglewood' AND team = 'Senior As'");

while ($getrow = mysql_fetch_assoc($get))
{
echo $getrow['email'];
}

?>

[Pikachu2000]

The query is failing and returning the boolean value FALSE. Echo mysql_error to see what error the db is returning.

[tebrown]

Thanks, solved the problem.

 

Much appreciated.

 

[darkfreaks]

don't forget to mark topic solved