Steven Macintyre wrote:
> Hi guys,
>
> Some intelligent minds needed again ...
I dont think I count - mostly because I don't even
understand the question.
> I have the following "schematic" to
> work to ...
>
> http//steven.macintyre.name/arb/showlineups.jpg
that URL make my browser end up here:
http://www.w3.org/Protocols/
is .name even a top level domain? did that happen whilst I was sleeping?
>
> 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.
in very broad terms (with out taking any account of error checking):
0. connect to mysql database
http://php.net/mysql
http://php.net/manual/en/function.mysql-connect.php
1. define an sql query
e.g. $sql = "SELECT * kayasite_schedule"; // lame example query
2. perform the query
http://php.net/manual/en/function.mysql-query.php
3. loop the result to output tabular data
http://php.net/manual/en/function.mysql-fetch-assoc.php
http://php.net/foreach
http://php.net/echo
>
> As always - your assistance appreciated!!
the manual is your best friend, if you don't understand something in the manual
(i.e. the links above) come back and ask ... don't forget to tell us where/what
you don't
understand :-)
good luck
>
>
>
> 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
