Hi,
I have the following table structure, as my installation of MySQL doesnt
support Foreign keys i have to maintain the referential integrity myself. So
if i delete a user, how can i make sure that the allocations from the
allocations table where the user_id is the same as the one being deleted
Hi!
I hope, I understood you right: You want to delete a user completely from
your database?
If yes, you can just do it step by step (I hope the last step - putting all
the queries together works):
$uid = 1;
$qry = 'SELECT `Allocation_ID` FROM `WMS_Allocations` WHERE
`User_ID`='.$uid;
$ent =