multiple tables

[raffael3d]

I have multiple tables. for the admin cener I made a button "approve" besides each entry. the admin center fetches all the data of all the tables into one. the problem is that all the different tables have entries with their ID's
if I would hit "approve?id?5" all entries with the ID 5 in each tables would be approved. I need now that besides the ID also each table is uniquliy indentified. I have no idea how to do that. any ideas?
so far it looks like that:

<? // If an entry has been approved set 0 to 1.
if (isset($approve)) {
     $query=mysql_query("UPDATE_scripts_SET_approved='1'_WHERE_id='$approve'"); ?>

[malbera]

first of all you should get rid of all those underscores

$query=mysql_query(" UPDATE scripts SET approved='1' WHERE id='$approve'");

[raffael3d]

I know! the underscores were generated by this forum, of course I have no underscores in my code.