PHP loop through query, first row

Question

I'm trying to output something special with the first row but it seems to output on every row, here is the code im using:

$query = mysql_query("SELECT * FROM chat WHERE id > '".$_GET["latest"]."' ORDER BY id DESC LIMIT 0, 20");
$number = mysql_num_rows($query);
$i = 1;
while ($row = mysql_fetch_assoc($query)) {

echo "<div class='babble' style='width:130px;overflow:hidden;margin:auto;'><a href=\"javascript:ajaxpage('user_profile.php?game=1&ajax=1&user=".$row['author']."', 'content');\" style=\"cursor:pointer;\"><font color=#ff4355><b>".$row['author']."</b></font></a><font color=#ff4355>:</font></b> ".$row['babble']."</div>";
   if($i = 1)
   {
       echo "<script type='text/javascript'>newestid=".$row['id']."</script>";
$i = 2;
    }
}

Rich Adams · Accepted Answer · 2011-01-20 01:36:30Z

7

You need to use the comparison operator ==, not the assignment operator = in your if statement.

if ($i == 1)

answered Jan 20, 2011 at 1:36

Rich Adams

26.7k4 gold badges43 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP loop through query, first row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related