mysql and msql_fetch_array

[artiemus]

<?php require "include.lib.php";


     $sql = "SELECT ibf_members.name, ibf_members.email   FROM ibf_members";
     $results = mysql_query($sql,$db);
     while ($userslist = mysql_fetch_array($results);
     {

     echo “email: ”. $userslist[‘email’] .”<br />”;
     echo “name:”. $userlidt[‘name’] .”<br />”;
       ”;
     }
       mysql_close($db);

?>

i keep getting this error
Parse error: parse error in c:\apache\htdocs\testa.php on line 10
on line 10 which is

while ($userslist = mysql_fetch_array($results);

am i doing anything wrong

[sgoku01]

Originally posted by artiemus
am i doing anything wrong

Yes 🙂

while ($userslist = mysql_fetch_array($results);

has to be:

while ($userslist = mysql_fetch_array($results))

So you have to close while with a ), and remove the ; at the end of the while command.

And why do you have "; on line 15?? That will be an error, if you don't remove it.
And on line 14 you have $userlidt...

[artiemus]

thnxs very much half asleep agian
😃