= '$d' order by Event_Date";
$dbs = msqlQuery( $sock, $query );
$dates = msqlStoreResult();
$index = 0;
while( $index < msqlNumRows( $dates ) ) {
$row = msqlFetchRow( $dates );
$day = (int)strseg( $row[2], 0, 1 );
$month = strseg( $row[2], 3, 5 );
$year = (int)strseg( $row[2], 7, 10 );
printf("$month $day, $year
");
printf("");
if( $row[5] != "" ) {
printf("- $row[5]");
}
if( $row[3] != "00:00:00" ) {
$hour = (int)strseg( $row[3], 0, 1 );
if( $hour > 12 ) { $hour = $hour - 12; $ampm = "pm"; } else { $ampm = "am"; }
$min = (int)strseg( $row[3], 3, 4 );
if( $min == 0 ) { $min = "00"; }
printf("
- $hour:$min $ampm");
}
if( $row[4] != "00:00:00" ) {
$hour = (int)strseg( $row[4], 0, 1 );
if( $hour > 12 ) { $hour = $hour - 12; $ampm = "pm"; } else { $ampm = "am"; }
$min = (int)strseg( $row[4], 3, 4 );
if( $min == 0 ) { $min = "00"; }
printf("
- $hour:$min $ampm");
}
if( $row[6] != "" ) {
printf("
- $row[6]");
}
if( $row[7] != "" ) {
printf("
- $row[7]");
}
printf("
");
$index++;
}
>
|
