[RESOLVED] while() loop not working

[TobyRT]

Hiya,

I'm going a little nuts here.

I'm using this code below to generate a list of names & email addresses.

The sql query is fine.
It returns the correct number of results

But when i try and echo the name and email addresses in a while loop, it doesn't work.

Can anyone point out the (I assume) blindingly obvious reason why this isn't working please? I've been on this for 3 hours now!

$mailinglist = mysql_query('SELECT * FROM mailinglist') or die(mysql_error());
			if (mysql_num_rows($mailinglist) > 0)
				{		
					echo 'names and emails'; //this displays OK
					echo '<br>'.mysql_num_rows($mailinglist); //this displays the correct number of results

				while ($mail = mysql_fetch_array($mailinglist));
						{	
						echo $mail['name'].' '.$mail['email'].'<br>';
						}
			}// endif num_rows

[drew010]

theres a ; on the end of the while line which shouldnt be there, removing that should do the trick

[TobyRT]

I knew it was obvious, but this is silly.

There's a semi-colon after my initial while() statment.

D'Oh.

Let this be a lesson to the rest of you at my expense.

On the upside, it usually seems that approimately 3 minutes after posting on this site, I work out the error myself.

Feel free to answer that question instead if you like!

[TobyRT]

Cheers drew - was typing my post as you mentioned it!