while loops

[supanoob]

[code]$query2="select player_id, news_msg, news_date, what_news, fight_name, fight_id, win_lose from news where player_id='$playerid' and win_lose='Lost'";
$result2=mysql_query($query2);
if (!$result2)
{
die (mysql_error());
}
while ($row = mysql_fetch_array($result2))
{
$row=mysql_fetch_array($result2);
$fight_id=($row['fight_id']);
$fight_name=($row['fight_name']);
$win_lose=($row['win_lose']);
echo "$fight_name($fight_id) Has Defeated You HAHA.<br>";
} [/code]

well ok so i have that and it is meant to echo "$fight_name($fight_id) Has Defeated You HAHA." that like so:

[quote]Stefan(1) Has Defeated you HAHA.
Stefan(1) Has Defeated you HAHA.[/quote]

but instead it does this:


[quote]Stefan(1) Has Defeated you HAHA.
Stefan(1) Has Defeated you HAHA.
() Has Defeated you HAHA.[/quote]

now i have checked and double checked my DB and i have no black fields. and i have checked and triple checked my code and i have not repeated the query anywhere else. i just cant see anything wrong with that code ^^

[toplay]

Get rid of this line inside the while loop:

$row=mysql_fetch_array($result2);

[code]
while ($row = mysql_fetch_array($result2))
  echo "{$row['fight_name']}({$row['fight_id']}) Has Defeated You HAHA.<br>";

[/code]

[Gast]

You have the "$row=mysql_fetch_array($result2);" part twice. This may be why. You only need it inside the while() loop.