Functions : Timestamp, text color, jpg appearrance

[patof]

:?:
Hi, I'm a php coding beginner. I went through alot of ressources during the weekend and I need some help only for three functions!!!

I use macromedia recordset. I have 5 fields in my table and I want these 3 functions:

Field

category- type of the field = enum

1-I want the text of the whole table(every fields) to be
white if value=sports
blue if value = hobby
2-I want different icons(sports.jpg, hobby.jpg) to appear
rather than the value

date- type of the field= timestamp
3-I want the date to appear in this format : Nov 19 2003.

These are the lines I want to edit...

<?php do { ?>
<table width="100%" border="0" cellspacing="2" cellpadding="2"><tr><th colspan="2" scope="col"><div align="left"><font color="#FFFFFF">

<?php echo $row_post['category']; ?></font><font color="#FFFFFF">
<?php echo $row_post['title']; ?></font><font color="#FFFFFF">
<?php echo $row_post['firstname']; ?>, ?></font><font color="#FFFFFF">
<?php echo $row_post['city_of_event']; ?></font><font color="#FFFFFF">
<?php echo $row_post['date']; ?></font><font color="#FFFFFF">

</td>

</tr></table><?php }

thanks
Andre

[jayant]

Change

<font color="#FFFFFF"> 
<?php echo $row_post['category']; ?></font>

to

<?php 
if($row_post['category']=="sports")
echo '<font color="#FFFFFF">'.$row_post['category'].'</font>';
elseif($row_post['category']=="hobby")
echo '<font color="#FFFFFF">'.$row_post['category'].'</font>';
?>

to have image instead of name

try:-
<?php
echo "<img src='".$row_post['category']."'>";
?>

for time formatting
see [man]date[/man] function

[portaloo]

$query = 'SELECT Name, DATE_FORMAT(VisitTime, '%m.%d, %H:%i:%s') as vtime FROM STATS';

%Y: Long year (2002)
%M: Long month (August, September)
%m: Numeric month (08, 09)
%d: Day of the month (01)
%W: Long day of the week (Monday, Tuesday)
%a: Short day of the week (Mon, Tue)
%H: Hour (01, 02)
%i: Minute (01, 02)
%s: Second (01)