[RESOLVED] simple foreach help.

[lozza1978]

Hi All

I have an sql statement

echo '<table width="200" border="1">';
while ($row = mysql_fetch_array($query)) {
	echo '<tr><td>'.$row['email'], '</td></tr>';
}
echo '</table>';

This statment pulls all the email address from the database into a nice little table,

Want I want to do is, create 2 cells,
in the first cell, I want it to say record-1, cell 2 displays the email address, and so on,

I think i need to use a foreach loop but not quite sure how to run it inside the while,

any help would be great,

thanks

lozza

[devinemke]

you do not need a foreach loop

echo '<table width="200" border="1">';
$i = 1;
while ($row = mysql_fetch_assoc($query))
{
	echo '
	<tr>
	<td>record #' . $i . '</td>
	<td>' . $row['email'] . '</td>
	</tr>
	';

$i++;
} 
echo '</table>';

[lozza1978]

ah got it,

everytime you go through the loop, you just increment $i at the end of the loop, very good,

thanks alot for your help.

lozza