Thank you for the heads up. I did notice that is must have a ; after every variable case entry, e.g. $bg = 'blue'; in order to work right. That was at least how I had to get it working. > -----Original Message----- > From: Becoming Digital [mailto:subs@becomingdigital.com] > Sent: Tuesday, June 17, 2003 9:51 PM > To: php-db@lists.php.net > Subject: Re: Select Statement with output in different colors. > > Here's a slight alteration to Peter's code in "case" someone isn't > familiar with > switch statements. Ooh, such a bad pun, as if there's any other kind. > > <? > $query = 'SELECT * FROM table > $mysql_result = mysql_query($query, $link); > > while($row = mysql_fetch_array($mysql_result)) > { > switch ($row["event"] ) > { > case event_one: > $bg = 'blue' > break; > case event_two: > $bg = 'red' > break; > case event_three: > $bg = 'green' > break; > default: > $bg = 'white' > } > print '<tr bgcolor="'.$bg.'"> > <td>da da da </td> > </tr>'; > }// end while > ?> > > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Peter Lovatt" <pjln1@sunmaia.net> > To: "Christopher Lyon" <cslyon@netsvcs.com>; <php-db@lists.php.net> > Sent: Tuesday, 17 June, 2003 17:42 > Subject: RE: Select Statement with output in different colors. > > > Try this > > $query = 'SELECT * FROM table > $mysql_result = mysql_query($query, $link); > > while($row = mysql_fetch_array($mysql_result)) > { > > > switch ($row["event"] ) > { > case event_one: > $bg = 'blue' > break; > case event_one: > $bg = 'red' > break; > case event_one: > $bg = 'green' > break; > default: > $bg = 'white' > > } > > > print '<tr bgcolor="'.$bg.'"> > <td>da da da </td> > </tr>'; > > > }// end while > > > > > HTH > > Peter > > > > -----Original Message----- > From: Christopher Lyon [mailto:cslyon@netsvcs.com] > Sent: 17 June 2003 22:35 > To: php-db@lists.php.net > Subject: Select Statement with output in different colors. > > > I have a php script that does some select statements, on mysql, and > outputs that to a table. I would like to change the color of the table > row depending upon one of the fields. The select statements are from a > syslog database that I have and I would like to highlight key events by > changing the colors for that row. Example would be MAJOR, yellow and > INFO, green. Does anybody have any examples of how to do this? > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
