Gossamer Forum
Home : General : Databases and SQL :

move data from 1 table to another with PHP

Quote Reply
move data from 1 table to another with PHP
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
Subject Author Views Date
Thread move data from 1 table to another with PHP barryb12000 11475 Jun 14, 2002, 1:52 PM
Thread Re: [barryb12000] move data from 1 table to another with PHP
Stealth 11183 Jun 15, 2002, 7:30 PM
Thread Re: [Stealth] move data from 1 table to another with PHP
barryb12000 11167 Jun 17, 2002, 7:22 PM
Thread Re: [barryb12000] move data from 1 table to another with PHP
Stealth 11159 Jun 17, 2002, 10:00 PM
Thread Re: [Stealth] move data from 1 table to another with PHP
barryb12000 11118 Jun 18, 2002, 8:48 AM
Thread Re: [barryb12000] move data from 1 table to another with PHP
Stealth 11141 Jun 18, 2002, 8:43 PM
Thread Re: [Stealth] move data from 1 table to another with PHP
barryb12000 11121 Jun 19, 2002, 1:42 PM
Thread Re: [barryb12000] move data from 1 table to another with PHP
Stealth 11164 Jun 23, 2002, 9:33 PM
Thread Re: [Stealth] move data from 1 table to another with PHP
barryb12000 11096 Jul 18, 2002, 1:16 PM
Post Re: [barryb12000] move data from 1 table to another with PHP
Stealth 10986 Jul 18, 2002, 2:05 PM