Page 1 of 1

Database design ideas, suggestions and help plz.

Posted: Sun Nov 09, 2003 8:03 pm
by metalator
So can someone hel me out with the following:
I need to create a database (using these fields)
(Using membership form for bands to sign up)

- Band ID <-- sohould be a unique number generated
- Band Name <-- member input
- Location
- Country: Canada and USA <-- member to select from drop down
- Region: Province and State <-- member to select from drop down
- City: <-- member to select from drop down
- Email <-- member input that could send and auto message like "thank you for signing up a rep will contact you soon"
- website <-- member input
- type of music <-- member to select from drop down

Contact info: all member input
- Band member1
Band member1 phone #
Band member1 email

- Band member2
Band member2 phone #
Band member2 email

- Band member3
Band member3 phone #
Band member3 email

- Band member4
Band member4 phone #
Band member4 email

here are the questions about this:
1. How should I design the database using all these fields
2. I want to use drop down option, is there a premade set with all provinces, states and cities?
3. How can i create an option that the band selects number of bands members and it will allow to enter that amount of contact info? Ex. if selects 3 member, only 3 member contact info boxes should come up.
4. is there a template available to handle this kind of membership?

and finally, I wanna be able to look at the database from a secure admin section and to be able to email all members

Please advise and help me out here?

Posted: Sun Nov 09, 2003 8:21 pm
by Gen-ik
"1. How should I design the database using all these fields "
>> If you have a database on your server then I suggest you use phpmyadmin if your host provides it. If not check out [php_man]mysql[/php_man]

"2. I want to use drop down option, is there a premade set with all provinces, states and cities?"
>> Have you tried searching Google or Yahoo?

"3. How can i create an option that the band selects number of bands members and it will allow to enter that amount of contact info? Ex. if selects 3 member, only 3 member contact info boxes should come up. "
>> Check out [php_man]switch[/php_man] or [php_man]if[/php_man]

"4. is there a template available to handle this kind of membership?"
>> Again try searching Google or Yahoo or visit http://www.phpnuke.org

Posted: Sun Nov 09, 2003 8:31 pm
by metalator
"1. How should I design the database using all these fields "
>> If you have a database on your server then I suggest you use phpmyadmin if your host provides it. If not check out mysql
I'm doing all of this on server installed on my system. I got "phpdev" kit and everything works fine. I am not good at coding and designing a database via code in the php, but i do have phpmyadmin which allows me to create databases and tables within them.
"2. I want to use drop down option, is there a premade set with all provinces, states and cities?"
>> Have you tried searching Google or Yahoo?
Ya i did some serching, but no luck maybe because i don't know a correct term for that kind of function/option

[/quote]

Posted: Sun Nov 09, 2003 8:52 pm
by metalator
trying to install phpnuke but whn i populate the database with tables this is the error that i get:

Error

SQL-query :

* - * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - * - * - CREATE TABLE confirm(

confirm_id char( 32 ) NOT NULL default '',
session_id char( 32 ) NOT NULL default '',
code char( 6 ) NOT NULL default '',
PRIMARY KEY ( session_id, confirm_id )
) TYPE = MyISAM

MySQL said:


You have an error in your SQL syntax near '---------------------------------------------------------
--
--

CREATE TABL' at line 2

Posted: Sun Nov 09, 2003 11:33 pm
by McGruff
If you are designing your own database rather than using phpnuke, this is worth a look: http://www.oreilly.de/catalog/javadtabp ... r/ch02.pdf

Posted: Mon Nov 10, 2003 12:13 am
by metalator
Damn, so much to learn so much to do... not enought time

Ok how about this. let say i skip the whole database thing and instead when bands submit their info... that info would just go into one text file or something.

So everytime someone signs up, their info gets a new row or entry in the document.
Same thing goes for emails, if i have just a text file or something just saving emails everytime someone signs up.

Any of this possible?

The reason why i say this is that i cannot figure out how to set up user/password in mySQL. Everytime i set a password and reload it usualy says can't access this mesql server or wrong password. Very frustrating