Gman — Mon, 02 Apr 2001 13:23:39 +0000

Many Thanks.

Peter J. Boettcher — Mon, 02 Apr 2001 13:09:01 +0000

Gman,

Just add the headings to be beside the database values instead of on top:

print "";
print "Date: ".$row["date"]."\n";

Repeat as necessary.

Gman — Mon, 02 Apr 2001 10:08:00 +0000

Here you go. I have left the top section out:

$query_result = mysql_query ("select date, event, club, status, notes from autotest order by date", $connection);

$mandate = "00-00-0000";
list($month, $day, $year) = sscanf($mandate,"%s %d %d");

if (mysql_num_rows ($query_result) >0){

print "\n";
print "DateEvent
ClubStatusContact\n";

while ($row = mysql_fetch_array($query_result)) {

print "";
print "".$row["date"]."".$row["event"]."".$row["club"]."".$row["status"]."".$row["notes"]."";
print "\n";
}

print "\n";

}
?>

Its not very neat I'm afriad

Mark Hensler — Mon, 02 Apr 2001 05:38:05 +0000

can you post the code you have?