ChrisMacPherson
Programmer
Hi All,
I have a problem here, which I think will probably need a tutorial to solve, so any appropriate links will be VERY appreciated.
I have a database with seven tables which hold details of a customers account. Each table holding seperate kinds of details (ie. address's, account config etc. etc.) I have set up primary keys and no foreign keys as they do not function in MySQL.
Now how do I implement the system so:
When I enter data to the tables, if there is an error on one table, then all the previous data that has been entered should be removed again. As if no entry has been made.
I am thinking about a making a function which is called when the error is found that will delete the last row of the tables that data has been entered into. Does this sound right or is there an easier way to do this?
If anybody has any links to using relationships in MySQL then I will be a very happy person!!! Chris MacPherson
thedamager@hotmail.com
Bring on the new Browza's!!
I have a problem here, which I think will probably need a tutorial to solve, so any appropriate links will be VERY appreciated.
I have a database with seven tables which hold details of a customers account. Each table holding seperate kinds of details (ie. address's, account config etc. etc.) I have set up primary keys and no foreign keys as they do not function in MySQL.
Now how do I implement the system so:
When I enter data to the tables, if there is an error on one table, then all the previous data that has been entered should be removed again. As if no entry has been made.
I am thinking about a making a function which is called when the error is found that will delete the last row of the tables that data has been entered into. Does this sound right or is there an easier way to do this?
If anybody has any links to using relationships in MySQL then I will be a very happy person!!! Chris MacPherson
thedamager@hotmail.com
Bring on the new Browza's!!