Jump to content

while loops


supanoob

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 ^^
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.