General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingGeneral Programming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old September 24th, 2002, 04:39 AM
nik_crash nik_crash is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2002
Posts: 6 nik_crash User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
1 column & 4 input type "text"

Sir/Ma'am,
Please help, how can i store the records in the database using 1 column & 4 input type of "text"?

for example:

Employer
text1
text2
text3
text4

Thank you for helping me...

Reply With Quote
  #2  
Old September 24th, 2002, 08:24 AM
wAr-AnGeL wAr-AnGeL is offline
Forum Security
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2002
Location: Behind You
Posts: 479 wAr-AnGeL User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 50 sec
Reputation Power: 17
Send a message via ICQ to wAr-AnGeL Send a message via AIM to wAr-AnGeL
Not sure exactly what you want to do but it sounds like some basic inserting into the database. You can check out Ben's article on PHP/MySQL basics in order to get a good idea how to do it. You can see it here .
__________________




"Only Linux users see the end of crashes."
- Pl4t0

Reply With Quote
  #3  
Old September 24th, 2002, 09:19 PM
nik_crash nik_crash is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2002
Posts: 6 nik_crash User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Sir/Ma'am,
Thank you for answering my question, here's example of what i'm saying for?Column of "Year Completed", "College/University",
"degree" is my problem?

Please see attached...
Attached Files
File Type: zip education.zip (574 Bytes, 590 views)

Reply With Quote
  #4  
Old September 25th, 2002, 05:50 AM
Ben Rowe
Guest
Dev Articles Newbie (0 - 499 posts)
 
Posts: n/a  
Time spent in forums:
Reputation Power:
sorry, had a look at the attachment, and i still dont get what your trying to do, maybe if you explained yourself in a bit more detail, and give a example

Reply With Quote
  #5  
Old October 16th, 2002, 02:45 AM
xavier xavier is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2002
Posts: 2 xavier User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
g'day Mate.

What does you MySQL Database table structure look like, Because if you are trying to update 4 sets of different information via a form, then you must have 4 sets of rows in ur MySQL table. so then it would be easy to update to.

Reply With Quote
  #6  
Old October 16th, 2002, 05:09 PM
FrankieShakes FrankieShakes is offline
Frank The Tank!
Dev Articles Beginner (1000 - 1499 posts)
 
Join Date: Jun 2002
Location: Toronto, Canada
Posts: 1,240 FrankieShakes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 18
Send a message via ICQ to FrankieShakes Send a message via MSN to FrankieShakes
Re: 1 column & 4 input type "text"

Quote:
Originally posted by nik_crash
Sir/Ma'am,
Please help, how can i store the records in the database using 1 column & 4 input type of "text"?

for example:

Employer
text1
text2
text3
text4

Thank you for helping me...


You have 2 options here... You can work heavily with joins, or you can create 3 tables:
PHP Code:
 Client:
Client_ID
Client_Name
etc...

Employer:
Employer_ID
Employer_Name
etc...

Client_Employer:
Client_ID
Employer_ID 

The last table would act as a look-up table to support the many-many relationship.

Hope that helps some...
__________________
____________________________________________
Developer Shed Weekly Writer | DevArticles Forum Moderator
Build Your Own KlipFolio Klip With PHP
FrankManno.com - Under Construction
Design Interactive Group - Under Construction

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingGeneral Programming Help > 1 column & 4 input type "text"


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap