Some advice / points / help

From: 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

« previous php.general (#246603) next »