[Resolved] update table1 from table2

joey3002

i have 2 tables in a db. in table 1, it has an id of certain info from table 2. i have redone somethings and want to update a new column in table 1 with data from table 2.

how would i do this?

the 3 items:
in table 1= table2ID
in table 1= origsubj (new column)
in table 2= subject (i want this in origsubj in table 1)

thanks guys

bradgrafelman

$query = "UPDATE  table1,table2  SET table1.origsubj =  table2.subject WHERE table1.table2ID = $id AND table2.id = $id";

I don't know how you're specifying which rows to update (i.e. giving it a table2ID to look for, which should match a corresponding column 'id' in table2, etc.) so you'll need to modify the WHERE clause to fit your needs, but I believe this should give you the basic idea.

joey3002

im just trying to run this in phpmyadmin

this is just a once and done type thing, i shouldhnt have to do it more than this one time.

bradgrafelman

So... does that mean it worked? Have you tried it yet?

EDIT: If it doesn't work, and you can't figure out how to adjust it to suit your needs as I said, post a dump of the structure of the two tables, and clarify which one was table1 in the example (the one being updated) and which one was table2.

joey3002

nope, it didnt work:

the 3 items:
news.webid
news.origsubj (this is what i want to fill, basically from web.subject, if origsubj =! web.subject update.. )
web.id (news.webid points to this)
web.subject

hope that is what you need to assist.

thanks

bradgrafelman

So you want to run this query once, and it will update all the matching ID's it finds? Try this:

UPDATE news,web SET news.origsubj = web.subject WHERE news.webid = web.id

EDIT: I tried this on my own server to double check, and it appears to work the way you want it to. Let me know if it doesn't.

joey3002

thank you so much, that did it!