Jump to content


Photo

arrays?


  • Please log in to reply
No replies to this topic

#1 Hooker

Hooker
  • Members
  • PipPipPip
  • Advanced Member
  • 193 posts
  • LocationWales, UK

Posted 13 June 2006 - 10:07 AM

Heya,

Ive been wondering how to do this for a fair while now and im sure its easy to do but im not 100% sure what im even looking for when looking for tutorials, basicaly im writing an events calander but when an event is made registerd users will be added to it by the creator.

So say i select i wanted 8 staff to go on a trip and each staff member can supervise 8 people, the forum would generate 8 columns with drop down boxes listing all the possible users (top box being the staff member) then it'd add all that information to the db and it'd be easily pulled out so everyone can see, ive got all the tables sorted:

// Divers personal information.
DROP TABLE IF EXISTS `Divers`;
CREATE TABLE IF NOT EXISTS `Divers` (
`Diver_id` int(3) NOT NULL auto_increment,
`Title` varchar(4) default NULL,
`Forename` varchar(32) default NULL,
`Init` varchar(1) default NULL,
`Surname` varchar(32) default NULL,
`ADDR1` varchar(32) default NULL,
`ADDR2` varchar(32) default NULL,
`ADDR3` varchar(32) default NULL,
`ADDR4` varchar(32) default NULL,
`ADDR5` varchar(32) default NULL,
`Postcode` varchar(8) default NULL,
`Tel1` varchar(15) default NULL,
`Tel2` varchar(15) default NULL,
`Mobile` varchar(15) default NULL,
`Email` varchar(50) default NULL,
`Padi_Level` varchar(20) default NULL,
`Hol_ADDR1` varchar(32) default NULL,
`Hol_ADDR2` varchar(32) default NULL,
`Hol_ADDR3` varchar(32) default NULL,
`Hol_ADDR4` varchar(32) default NULL,
`Hol_ADDR5` varchar(32) default NULL,
`Hol_Tel` varchar(15) default NULL,
`Next_Kin` varchar(30) default NULL,
`DOB` varchar(8) default NULL,
`Staff` varchar(8) default NULL,
PRIMARY KEY (`Diver_id`,`Forename`,`Surname`,`Postcode`),
) TYPE=MyISAM;

// Events, set in the calander
DROP TABLE IF EXISTS `Event_log`;
CREATE TABLE IF NOT EXISTS `Event_log` (
`Event_id` int(3) NOT NULL auto_increment,
`Date` date NOT NULL default '0000-00-00',
`Activity` date NOT NULL default '0000-00-00',
PRIMARY KEY (`Event_id`,`Date`,`Activity`),
) TYPE=MyISAM;

// Dive logs, this matches divers to dives and checks if theyre staff for that event.
DROP TABLE IF EXISTS `Divers_log`;
CREATE TABLE IF NOT EXISTS `Divers_log` (
`Diver_ID` varchar(15) default NULL,
`Event_ID` varchar(15) default NULL,
`Diver_Level` varchar(15) default NULL,
PRIMARY KEY (`Diver_ID`,`Event_ID`,`Diver_Level),
) TYPE=MyISAM;

its for a diving community i belong too, basicaly the info from all the other divers is kept in one table, the events are kept in another and then theres a third table that matches them all up, ive got all that down im just wondering about the input.

ive been looking into ajax etc to do this sort of thing without refreshing the form but again im not entirely sure what im looking for. any links to tutorials/examples would be greatly appreciated




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users