The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Hi there.
Gonna keep this short.
Anyone know a way of deleting a record from multiple tables?
I tried this syntax: -
DELETE * FROM auction,keyfeatures,images WHERE ID=$theID
Doesn't want to work though.
The table 'auction' uses what is in $theid as it's primary key.
The other two tables have whatever $theid is as it's secondary key
Cheers for any help.
Gonna keep this short.
Anyone know a way of deleting a record from multiple tables?
I tried this syntax: -
DELETE * FROM auction,keyfeatures,images WHERE ID=$theID
Doesn't want to work though.
The table 'auction' uses what is in $theid as it's primary key.
The other two tables have whatever $theid is as it's secondary key
Cheers for any help.
Page:
There have been no replies to this thread yet.
Hi there.
Gonna keep this short.
Anyone know a way of deleting a record from multiple tables?
I tried this syntax: -
DELETE * FROM auction,keyfeatures,images WHERE ID=$theID
Doesn't want to work though.
The table 'auction' uses what is in $theid as it's primary key.
The other two tables have whatever $theid is as it's secondary key
Cheers for any help.
Gonna keep this short.
Anyone know a way of deleting a record from multiple tables?
I tried this syntax: -
DELETE * FROM auction,keyfeatures,images WHERE ID=$theID
Doesn't want to work though.
The table 'auction' uses what is in $theid as it's primary key.
The other two tables have whatever $theid is as it's secondary key
Cheers for any help.
Page: