wierd problem with a query....

[Anon]

Hello,

I have this query :

$query = mysql_query("SELECT * FROM s_mail_list_mails WHERE list='$id'") or die(mysql_error())

---

and all work fine,

but then I try this :

while($data = mysql_fetch_array($query) or die("while problem"))
{

   }

---

and the script "die's"....
what can be the problem ?
the query is 100% correct ! and also I try to mysql_num_rows($query) or die() and the same problem appears...

someone can help ?

THANKS.

[claire]

you can't die in a while line

just write

while($data = mysql_fetch_array($query)) {

and you'll be OK!