[CS-FSLUG] Looking for tips

[Frank Bax]

At 01:43 PM 7/2/04, David M. wrote:

>On Friday 02 July 2004 01:06 pm, Aaron Patrick Lehmann wrote:
> > Couldn't you just use php or perl to create the tables?  That way, you
> > could use a conditional to create a different page if there wasn't any
> > data.
>
>I still have to use html to create the tables, PHP can't create tables as far
>as I know, but I can use PHP to control the tables.


PHP simply uses 'echo' statements to output html code, so anything you can 
do in html, you can do in php.  I use pgsql instead of mysql, but the code 
below might be helpful.


     $sql = "SELECT"
          . "  date_part('epoch',dateopen) as dateopen,"
          . "  date_part('epoch',datedue) as datedue,"
          . " place, event  FROM $_table"
          . " WHERE age(dateopen,now()) > '9week ago'::interval"
          . " ORDER BY task, dateopen";
     $Result = $pg_query( $sql );
     $NumRows = pg_NumRows($Result);
     if( $NumRows == 0 ) {
       echo '<P><CENTER>No events scheduled</CENTER><P>';
     } else {
       echo '<TABLE BORDER=1 ALIGN=CENTER CELLPADDING=5>', "\n";
       echo '<TH>Date</TH><TH>Place</TH><TH>Event</TH></TR>', "\n";
       for ($CurRow =0; $CurRow < $NumRows;  $CurRow++) {
         $row = pg_Fetch_Object($Result, $CurRow);
         echo '<TR><TD>', date('F',$row->lodate), ' ', 
date('j',$row->lodate);
         if( $row->lodate <> $row->hidate ) {
           echo " -";
           if( date('M',$row->lodate) <> date('M',$row->hidate) )
             echo ' ', date('M',$row->hidate);
           echo ' ', date('j',$row->hidate);
         }
         echo '</TD><TD>', $row->place, '</TD>';
         echo '<TD>', nl2br(wordwrap($row->event,50)), '</TD></TR>', "\n";
       }
       echo '</TABLE><P>';
     }
     pg_FreeResult( $Result );
   }