Query Result Format

sfmnetsys

Goal of formatting:

Data put into table
Date formatted to mm/dd/yyyy
Rows alternating color

This is what I have so far. This puts my query results into a table. I know how to format the date, but not with the code in the format it is below. Any suggestions would be greatly appreciated.

Thanks.

<?php

    $db=mysql_connect ("localhost", "username", "password");
    mysql_select_db ("dbname", $db);
    $result=mysql_query ("select * FROM tablename", $db);
    print ("<TABLE BORDER=3>\n");
    print ("<TR><TH ALIGN=LEFT>Date</TH><TH ALIGN=LEFT>Race Name</TH><TH ALIGN=LEFT>Time</TH><TH ALIGN=LEFT>Dist.</TH><TH ALIGN=LEFT>City/State</TH>\n");
    while ($row=mysql_fetch_row ($result)) {
            print ("<TR><TD>$row[6]</TD><TD>$row[0]</TD><TD>$row[1]</TD><TD>$row[2]</TD><TD>$row[3], $row[4]</TD>\n");
    }
    print ("</TABLE>\n");
    mysql_close ($db);
    ?>

Anon

Try this...

<?php

$db=mysql_connect ("localhost", "username", "password");
mysql_select_db ("dbname", $db);
$result=mysql_query ("select date_format(your_date,'%m/%d/%Y') AS nice_date,* FROM tablename", $db);
print ("<TABLE BORDER=3>\n");
print ("<TR><TH ALIGN=LEFT>Date</TH><TH ALIGN=LEFT>Race Name</TH><TH ALIGN=LEFT>Time</TH><TH ALIGN=LEFT>Dist.</TH><TH ALIGN=LEFT>City/State</TH>\n");
$i=0;
while ($row=mysql_fetch_row ($result)) {
print ("<TR");
if ($i % 2) print (" BGCOLOR=#CCCCCC");
print ("><TD>$row[1]</TD><TD>$row[1]</TD><TD>$row[2]</TD><TD>$row[3]</TD><TD>$row[4], $row[5]</TD>\n");
$i++;
}
print ("</TABLE>\n");
mysql_close ($db);
?>

Boris
http://www.belcombailey.com

sfmnetsys

With the above I get the error

Warning: Supplied argument is not a valid MySQL result resource in E:\MNS\Development\Dev.Projects\the-fitzgeralds.net\scripts\tresults.php on line 11

Line 11: while ($row = mysql_fetch_row ($result)) {

This indicates to me that there is a problem with the code:
$result=mysql_query ("select date_format(your_date,'%m/%d/%Y') AS nice_date,* FROM tablename", $db);

Any ideas?