[SOLVED] Can't understand why... (WHILE LOOP)

[numtre]

Hello everyone

This is my first post, I'm kind of a php/mysql newbie so i would appreciate any help

 

Here's my simple code:

 

<?php

		$con = mysql_connect("localhost","inteoria_crash","****");

		if (!$con)
			{
			die ('Could not connect.'.mysql_error());
			}

		mysql_select_db ("inteoria_vera",$con) or die(mysql_error());

		$result=mysql_query("SELECT * FROM tblNews");


		$row=mysql_fetch_array($result);


		echo "<ul>";

		while ($row=mysql_fetch_array($result))

			{
			echo "<li><span class='bold'>".$row['date']."</span>: ".$row['content']."</li>";
			}
		echo "</ul>";

		mysql_close($con);
		?>

 

Now, my question is: If I have four records in my DB:

 

http://img353.imageshack.us/my.php?image=picture2wv0.png

 

Why the hell do I only get to see 3?

 

http://img151.imageshack.us/my.php?image=picture3xr1.png

 

[PFMaBiSmAd]

Because the following line in your code is fetching the first row from the result set and not using -

 

$row=mysql_fetch_array($result);

 

Why do you have that line of code in your code?

[numtre]

thx for pointing me in the right direction

clearly i'm missing some basics

 

i'll be back soon