Either this is giving me a headache, or the headache makes me forget what to do

[badgoat]

Hi,

My goal is to select someone from the drop down menu.. Once I select someone, their ID gets added to a table. I then want to display the person I just added in a table below the dropdown menu and add to the list as more people are added.

I am forgetting what I should do first, and in what order the sql statements go, since I want to insert into a table and then read from another based on what I entered into the first one. What should I do first? Next?

<form action="select_onsites.php" method="post">  

<select name="dropdownonsite" tabindex="4" onChange=submit()>
<option value="notset">- Select a Member -</option>   ';


                    //--- CREATE ONSITE MEMBER SELECT ---
                    $sql = "SELECT DISTINCT id, onsitename FROM onsite ORDER BY onsitename";
                    $onsitename = mysql_query($sql) or die($sql . '<br />' . mysql_error());
                    while ($row = mysql_fetch_array($onsitename)) {
                    echo '<option value="' . $row['id'] . '">' . $row['onsitename'] . '</option>';
                    }   ;

echo '</select></form>

[bpat1434]

Just use a normal insert as you would for any other information. Then, before you redirect, just grab the query information you want from the $_POST[] array and then query the database. Now, since it seems you're doing this all in one page, you can use that value to populate a table underneath the drop-down as you stated.

~Brett

[badgoat]

Hi bpat,

Before the migraine, I had this all figured out..

What's the best table format? Currently, the users are stored in a table:

table users
id | name | firm | phone

And the event which the users will attend has a table:

table event
id | event_name | location | etc..

I imagine that I should use a relational table to associate the users with the event... But the numbers of people will vary.. And with what I would like to do, how do I change the variable for each new additional user? I was thinking that a relaional table with user1 thru user10 would work, but now, I question that.

[bpat1434]

I would use this table format:

|  ID  |     Name    |   Firm  |  Phone Number  |
+------+-------------+---------+----------------+
|   1  |  Joe  Dirt  |  Firm 1 | [phone] |
|   2  |  Joe Schmoe |  Firm 2 | [phone] |
+------+-------------+---------+----------------+


|  ID  |   Event   |  Location  |  Attendees  |
+------+-----------+------------+-------------+
|   1  |   Picnic  |  Not Here  |     1,2     |
|   2  |  Workday  |  Not Here  |      1      |
|   3  | Golf Game | 18th  Hole |      2      |
+------+-----------+------------+-------------+

I would use that type of setup. Then, when you want to find out who went to what, you have a CSV field that relates to the ID of the user table.

Make sense?

~Brett

[badgoat]

Yep, I follow ya.. I have a new question then.. In your second table the attendees column allows for more than one attendee.. How do I accomplish that?

[bpat1434]

Just insert into the table ",user_id".

You would just add an insert statement, or UPDATE statement to append the column you want to add.

~Brett