Re: Some advice / points / help
| From: | Richard Lynch | Date: | Fri, 05 Jan 2007 22:00:45 +0000 |
| Subject: | Re: Some advice / points / help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-246632@lists.php.net to get a copy of this message | ||
On Fri, January 5, 2007 9:07 am, Steven Macintyre wrote:
> Hi guys,
>
> Some intelligent minds needed again ... I have the following
> "schematic" to
> work to ...
>
> http//steven.macintyre.name/arb/showlineups.jpg
>
> I need to "fill" that with data from a mysql table ...
>
> The format of the table is as follows;
>
> CREATE TABLE
kayasite_schedule (
> id int(11) NOT NULL auto_increment,
> tid int(6) NOT NULL,
> showname mediumtext NOT NULL,
> day varchar(10) NOT NULL,
> blurb longtext NOT NULL,
> show_start time NOT NULL default '00:00:00',
> show_end time NOT NULL default '00:00:00',
> who varchar(25) NOT NULL default '',
> uid int(6) NOT NULL,
> pic varchar(60) NOT NULL default '',
> UNIQUE KEY id (id)
> ) ENGINE=MyISAM
//I always get date_format directives wrong. Look them up.
$query = "select id, tid, showname, day, date_format(show_start,
'%h%a'), date_format(show_end '%h%a') ";
$query .= " from kayasite_schedule ";
$query .= " order by day, show_start ";
$shows = mysql_query($query, $connection) or
trigger_error(mysql_error($connection) . " $query");
$last_day = '';
$columns = array();
//The interesting thing to note is that the layout of start-times
//is actually very free-form
//So don't try to structure it too much!
echo "<table><tr
valign=\"top\"><td><b>Mon-Thu</b><br />";
while (list($id, $tid, $showname, $day, $show_start, $show_end) =
mysql_fetch_row($shows)){
if ($day !== $last_day){
echo "</td><td><b>$day</b><br />\n";
$last_day = $day;
}
echo "<b>$show_start-$show_end</b><br />\n";
echo $showname, "<br />\n";
echo "<br />\n";
}
echo "</td></tr></table>\n";
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?