Help With MySql Query and Displaying Results

[bunker]

Hi,

Could someone please explain why and how to solve the followin problem:

I have a very simple table with several fields...

id, cat and text for example.... and I know there are 5 records ... from id=1 to id=5 but with the following code only 4 are displayed!!

Code:

$sql_menu = mysql_query("SELECT * FROM menu_izq");
$num_menu = mysql_num_rows($sql_menu);
$row_menu = mysql_fetch_array($sql_menu);

while ($row_menu = mysql_fetch_array($sql_menu)) {
echo $row_menu[text]
}

thx in advanced 🙂

[devinemke]

$result = mysql_query('SELECT * FROM menu_izq') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['text'] . '<br>';
}