combined tables and approve

[raffael3d]

I created an admin module: if a user ads an entry to the databse the colum "approve" will be set to 0. after it is approved by the admin it is set to 1 and visible for everybody. so far everything ok.
now I have many different tables. I will now make that all the new entries that were made are shown in a single table.
besides every new entry you will have a button "approve" that if it's hit will change the "approve" value from 0 to 1.
but it 's not working properly, because the data is fetched from many different tables and the ID's are mixed up that way, so maybe it has three ids with the id "3"
what do I have to do that the "approved" is set in that table where it should?

[malbera]

add something to that id
id 1 from table 1 ---> $id=11
id 1 from table 2 ---> $id=21

and so on
hope that helps

[the_Igel]

You nearly answered by yourself: you must have not only id, but some table handle too. It may be table name or smth. Then you will know, what table a record belongs to.