Re: PHP Program Schedule
| From: | Jay Fitzgerald | Date: | Tue, 08 Apr 2003 13:50:59 +0000 |
| Subject: | Re: PHP Program Schedule | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26927@lists.php.net to get a copy of this message | ||
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) {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: bayoujfecho "<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-DB] 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