alert for new update in php or javascript

Question

How to change background color for last render row in while loop ....

that is

row1
row2
**row3**

If row4 is added then it should

row1
row2
row3
**row4**

that is star represents some bgcolor red...

this loop am following,,,, $i = 1; while ($row = mysql_fetch_assoc($sql)) {

$out_data[] = "<p>$i {$row['news']} </p>";

$i++;
}

$divider = '<div class="border"></div>';
$output = implode ($divider, $out_data);

echo $output;

Anand · Accepted Answer · 2010-07-31 13:59:38Z

2

you can use mysql_num_rows to get the number of rows you have before the while loop.

 $row_count = mysql_num_rows($sql)

inside the while loop

 if ($i==$row_count)
    // put color $out_data[] = "<p style="colorsomething">$i {$row['news']} </p>";
 else
    // dont put color $out_data[] = "<p>$i {$row['news']} </p>";

does this help?

answered Jul 31, 2010 at 13:59

Anand

4,2527 gold badges44 silver badges56 bronze badges

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

Comments

pop850 · Accepted Answer · 2010-07-31 14:10:25Z

0

EDIT: You'd need to change the formatting for the last element of $out_data like this: (once the while loop completes)

…
$out_data[ count($out_data) - 1 ] = "<div style='background-color:red'>" . end($out_data) . "</div>"

$divider = '<div class="border"></div>';
$output = implode ($divider, $out_data);

echo $output;

how does that work?

edited Jul 31, 2010 at 14:10

answered Jul 31, 2010 at 13:24

pop850

3,1573 gold badges31 silver badges34 bronze badges

6 Comments

Bharanikumar Over a year ago

assume....to put an alternate row color we know...we use somthing like this formulat...and make alternate row colors $tr_color = $i%2;

pop850 Over a year ago

The background-color property can be in the rgb(0-255, 0-255, 0-255) format or in hex color codes.

Bharanikumar Over a year ago

what should i put instead of last time condition is true

Bharanikumar Over a year ago

what is the test case i should put there.

pop850 Over a year ago

Could I see your while loop condition?

|

Collectives™ on Stack Overflow

alert for new update in php or javascript

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related