Forum Moderators: coopster

Message Too Old, No Replies

autopopulate dropdown list from database

newbie looking for a starting point

         

brdwlsh

7:31 pm on Aug 21, 2006 (gmt 0)

10+ Year Member



hi -

problem:
an events-registration page with a form containing a dropdown list for upcoming events, the events will be pulled from a table which is updated by...?

what i've gathered so far is that this can be done with PHP. I am a little unclear on the concept of how this is done. How does the updated information get input into the table?

1) can this be done (updating database) through a web interface by the client, or is it something i would have to do locally and then upload. If done by the client, can he delete/edit existing information--assuming he is not familiar with code.

2) what other things aside from html(good), sql(so-so), and php(newb) will i have to know?

i've seen a lot of good tutorials here and will have access to the necessary software. I just want to know if there is anything else i should know before i dive in head first without testing the PHP water, which i assume is frigid.

i'll be lurking around here for a while.

the_nerd

8:48 pm on Aug 21, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Try and split your goal into sub-tasks, like

1. Get a trivial query running and show the result with php
2. populate a form with data you just read from a database
3. when the form is submitted simply output the form entries.
4. build a query that updates a record in a db (you wrote that you know some sql already)

You'll find lots of tutorials about these simple tasks.

When all this works you have to make the user interface foolproof, hack- and spam-proof. That will consume most of the time.

Far from complete - but maybe it's a start. Remember your task is like a jigsaw puzzle, you might have to stare at some parts for a while - buti nthe end everything falls into place.

Good luck.