Question about ouputting (?) variables

Monqui

Heres what my block of PHP code looks like (Its set up in a function that takes in the # of times ($ShowNum) it should run thru the code)

<?
$queryShowNews = "SELECT * FROM News ORDER BY ID Desc";
$result = mysql_query($queryShowNews) or die("Query failed");

while(($line = mysql_fetch_array($result, MYSQL_ASSOC)) && ($Counter < $ShowNum))
{
?>
<tr>
<td Width="100%">
<?print $result["Date"]?>
<br>
<?print $result["NewsItem"]?>
</td>
</tr>
<tr>
<td align="right">
<a href="mailto:<?print $result["UserEMail"]?>"><?print $result["User"]?></a>
</td>
</tr>
<?
$Counter = $Counter + 1;
}
?>

but in the source of the page each entry reads:

it does that the right # of times.

I've tried replacing the print commands with echo, but the output is still the same... Any ideas?

(Sorry the indentation is so bad... I tried 2 spaces but they dont stick)

TouchTheClouds

If i did understand your problem right, try smth like this:

$result = mysql_query("your query variable") or die("blabla");
$numb = mysql_num_rows($result);

for ($i=0; $i<$num; $i++) {
$row = mysql_fetch_array($result);
echo $row["NewsItem"];
echo "<BR>";
echo $row["Another_Row_of_the_table"];
}
?>

MrAlaska

If you miss the differance between TouchTheCloud's example and your own code, $line owns the array, not $result

<?print $line["Date"]?> should work a little better.