Database Systems Help

Abstract · April 11 '09, 05:16 PM (#1)

Man I hope I didn't open up a can of worms with this one. I am hoping it is simple.... How do I query a database for a value and input that value into another field?

For instance, let's say I have a person filling out a form. Their name (field_id=1), will populate their name somewhere else (field_id=10). How do I do this? I am trying to research the issue, but being that MySQL is not my expertise, I might not be using the proper words in my search...

Any help is appreciated. Thanks.

**Shadowfiend** · April 12 '09, 09:24 AM (#2)

Hm. I mean, you can just do it in two steps: do a SELECT name FROM table WHERE field_id = 1, and then do an UPDATE table SET name = '<name>' WHERE field_id = 10 but put the name you got from the first query in for the <name> placeholder in the second one.

Abstract · April 12 '09, 11:35 AM (#3)

When you refer to '<name>' is this the field name or is this the value? There is a whole bunch of entries already for field_id=1. So I want it to automatically populate field=10.

Basically, I have 2 separate database tables. I want 'field_id=1' to automatically populate 'field_id=10'. Data is stored in one table from people filling out a form (this is where field_id=1 is located). Managers will access data in the other table that dynamically pulls in the name (field_id=10).

I hope that clarifies it better. Since this is the case, would what you mentioned above be the code I am looking for?

**Shadowfiend** · April 12 '09, 11:41 PM (#4)

I'm still not 100% clear on it. Give us a specific example with rows from each table (you can make up the columns/data, obviously) and that should help us understand.

Abstract · April 13 '09, 12:16 PM (#5)

Sorry for the lack of clarity; I am hoping that I can simplify my explanation here:

A person fills out a form that includes their 'name'.
This information will be stored in a database table.
I want that 'name' to also populate another database table, in which managers access.

Abstract · April 14 '09, 12:17 AM (#6)

here is my stab at it:

Code:

$sql = "SELECT * FROM table_1 WHERE field_id=1";
$result = mysql_query($sql);

while($row = mysql_fetch_array($result))
{
echo $row['value'];
}

$sql = "INSERT INTO table_2 (value, field_id) VALUES ('$result', '10')";

I got it to successfully query the database, but now I need it to populate table_2 with the field_id column to be '10' and the value column to equal the query from table_1. There is something I got wrong here. HELP!

**Shadowfiend** · April 14 '09, 01:37 AM (#7)

Well you probably shouldn't be quoting the 10. Other than that, make sure you run mysql_query with the second SQL statement.

Abstract · April 14 '09, 07:27 PM (#8)

Gotcha. Will do. Thanks!

darknailblue · June 19 '09, 08:55 AM (#9)

Why bother at all having 2 queries? Why not just add some kind of status field to you table? This way you can have 1 table avoid duplicates, and query the DB using something like a WHERE status = 2 or whatever. Then you can accomplish things like this...

Status Codes

1 = Regular User
2 = User w/ Management Privileges
3 = Unactive User

etc. etc. etc.

Database Systems Help

One field equals the value of another field