Jump to content

Archived

This topic is now archived and is closed to further replies.

supanoob

while loops

Recommended Posts

[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 ^^

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
You have the "$row=mysql_fetch_array($result2);" part twice. This may be why. You only need it inside the while() loop.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.