Updating multiple tables...

[Mr_Mako]

I have two tables I need to have updated at the same time when a user inputs data into the form, a "users" table and a "applications" table. What I need to have happen is that the "applications" table is updated with each app having a unique ID#, and then the "users" table referencing the "applications" table and getting updated at the same time.

The problem is that I can get this to happen somewhat... but I can't get the "users" table to get updated under the correct username. It simply adds a new record with an empty username. How do I force the code to place the data into a specific username record?

I've been searching also for a code snippet example of how to populate a dropdown menu with data from a table... and haven't been able to find it. I didn't bookmark when I found it last (and regret it now...).

Thanks...

[jburfield]

You don't say what db you are using, however, assuming MySQL, ff the username is a primary key, you can do a REPLACE statement.

-> REPLACE into table (field1, field2, field3) values(value1, value2, value3);

If username is a primary key it will delete the current record and add a new one with the newer information.

OR...why not just use an UPDATE statement?

For the drop down:
<select name="xxx">
$query = "select distinct(name) from sometable";
$result = mysql_query($query, $db_connection);
while($row = mysql_fetch_row($result))
{
$name=$row[0];
print("<option name='xxx' value='" . $name . "'>" . $name . "\n");
}
</select>

That will populate a drop menu with the values from the 'sometable' table. This is a very simple example, but it should point you in a good direction I think.

-- Jason