Some advice / points / help
| From: | Steven Macintyre | Date: | Fri, 05 Jan 2007 15:07:07 +0000 |
| Subject: | Some advice / points / help | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-246603@lists.php.net to get a copy of this message | ||
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
Now, as you can see the time slot are the items "show_start", "show_end"
(which I can do) the names are from the table (who) - can anyone start me
off on the correct route to get this done.
The layout does not have to be exactly like that - but - the days across top
have to - so if there are gaps in "time slots" etc we can handle that
This is way beyond my level of knowledge and have NO idea where to start.
As always - your assistance appreciated!!
Kind Regards,
Steven Macintyre
http://steven.macintyre.name
--
http://www.friends4friends.co.za