Re: PHP Program Schedule

Jay Fitzgerald <jayfitz@bayou.com> · Tue, 08 Apr 2003 08:50:59 -0500

Actually, now I am really lost....I'm a newbie at mysql and php so I tried 
my best at what I thought Micah was pointing out, but I get all kinds of 
errors and warnings....can someone help please? I will owe you a 12-pack :-)

Here is my code which produces these: http://www.kcla-tv.com/admin2/help2.php:

<?

$connection = mysql_connect("*************","******","*******") or 
die("Couldn't make connection.");

$db = mysql_select_db("*****", $connection) or die("Couldn't select 
database.");

$sql = "SELECT *, (DAYOFWEEK(enddate)-DAYOFWEEK(startdate)+1) as numdays 
from schedule group by airtime order by airtime asc";

$sql_result = mysql_query($sql,$connection) or die("Couldn't execute query.");

for ($i = 0; $i <= 48; $i++):

   echo "<TR>";

   $airtime = $row["airtime"];

   list ($hour,$min,$sec) = explode(":", eregi_replace("[' '|-]",":", 
$airtime));

   $unix_timestamp = strtotime($airtime);

   $formatted_time = date("g:i A",$unix_timestamp);

   $timeslot = array("$formatted_time");

   echo "<TD ALIGN=\"center\" VALIGN=\"top\"><FONT FACE=\"Arial, 
Helvetica\"><B>$timeslot[0]</B></TD>";

   while ($row = mysql_fetch_assoc($airtime)):

      $airid = $row["airid"];

      $startdate = $row["startdate"];

      $enddate = $row["enddate"];

      $airtime = $row["airtime"];

      $airshow = $row["airshow"];

      $airlength = $row["airlength"];

      $numdays = $row["numdays"];

      $program = array("$airshow");

      echo "<TD ALIGN=\"center\" VALIGN=\"top\" COLSPAN=$numdays><FONT 
FACE=\"Arial, Helvetica\">";

      echo $row["airshow"];

      echo "</FONT></TD>";

   endwhile;

   echo "</TR>";
endfor;

mysql_free_result($sql_result);
mysql_close($connection);
?>

At 05:59 PM 4/7/2003 -0700, Micah Stevens wrote:
Yes.. Do this:

<table>
<tr>
<td><? // loop through the column headers here?></td>
</tr>
<?
 for (each time slot) {
        echo "<tr>";
        $data = (get db data for that timeslot)
        while ($d = mysql_fetch_assoc($data)) {
                echo "<td>";
                echo $d['your data'];
                echo "</td>";
        }
        echo "</tr>";
}

</table>

see what I'm getting at?

On Monday 07 April 2003 2:59 pm, Jennifer Goodie wrote:
> It seems that your table structure is bad.  Maybe put a border=1 in the
> table tag so you can see what is going on.  In my experience using the <tr>
> and </tr> tag to define what goes in which row is the way to go.
>
> > -----Original Message-----
> > From: Jay Fitzgerald [mailto:jayfitz@bayou.com]
> > Sent: Monday, April 07, 2003 2:58 PM
> > To: php-db@lists.php.net
> > Subject:  PHP Program Schedule
> >
> >
> > I am lost on this one...
> >
> > Example 1: http://www.kcla-tv.com/admin2/test.php
> > this looks fine on the frontend, except when you look at Example 2
> >
> > Example 2: http://www.kcla-tv.com/admin2/test2.php
> >
> > These shows (Living the Life Gerbert How Can I Live GDM Ministries See
> > Mores) are supposed to be on the next table row for the time
> > 6:00; however,
> > I cannot for the life of me figure out why this isnt working...
> >
> > Does anyone have any clues?
> >
> >
> > Jay Fitzgerald, Design Director - CPW-A, CPWDS-A, CPWDV-A, CECM-A,
> > CWCSB-A Bayou Internet - http://www.bayou.com
> > Toll Free: 888.30.BAYOU (22968)
> > Vox: 318.338.2034 / Fax: 318.338.2506
> > E-Mail: jayfitz@bayou.com
> > ICQ: 38823829 / AIM: bayoujf / MSN: bayoujf / Yahoo: bayoujf

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Jay Fitzgerald, Design Director - CPW-A, CPWDS-A, CPWDV-A, CECM-A, CWCSB-A
Bayou Internet - http://www.bayou.com
Toll Free: 888.30.BAYOU (22968)
Vox: 318.338.2034 / Fax: 318.338.2506
E-Mail: jayfitz@bayou.com
ICQ: 38823829 / AIM: bayoujf / MSN: bayoujf / Yahoo: bayoujf

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php