move record from 1 table to another

[Anon]

Hello,
Can someone help with this problem I'm having.
I have 2 mySql tables, let say 1 contains cars in it and the other is a user table.
What I'm tring to do is have the user select a car from the list and add to there own record. But I would like the car that the user selected to be removed from the table after they have added it so no one else can add it to their record.

Picture a table on the left of the screen and a table on the right side and 2 submit buttons in the middle that say "ADD" and "Remove". The user can select a car from the table on the left to add to the table on the right or reverse. But I want the record to be moved not copied
Thanks

[Anon]

Instead of trying to move the row of data from one table to the next, why not add an extra field (an Owner field) to the cars table that contains the current owner's User ID. Then when a user "absorbs" a car, you will UPDATE the car's row so it's Owner field contains the user's id. If the user "drops" a car, you will UPDATE the car's row so it's owner field is empty.

On the left side of the screen, you display all the car's that have an Owner field equal to the user. On the right side of the screen, you display all the car's that have an Owner field that's empty.

It's pretty simple actually. Hope that helps. If you want some additional code examples, come to my website AaronZoller.com.

AaronZoller.com
http://www.aaronzoller.com

[barryb1]

Thanks for your help. I will stop by your site to get more info.
Thanks again.