Posted by J.O. Aho on 12/10/06 15:13

ulyx wrote:
> If i have table users ( with 10 fields) and if i want to ( users are listed,
> and you can choose them thru button click ) move one of those users to
> second table ( called VIP ). what should i do ?
>
> When i move this user from one to other table then this user will be just in
> one table ( VIP ). There is no double entries.

Why not just add another column to mark if the user is VIP or not?

You can SELECT the userdata from the user table, and then INSERT the data into
vip table if this goes okey, then just use a DELETE to remove the user from
the user table.


PS. Added the alt.php.sql newsgroup, as it's a more proper place for this kind
of questions IMHO.


//Aho

[Back to original message]