Some advice / points / help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux