PHP Mysql best practise
Posted: Thu Oct 03, 2013 5:01 am
Good day all
I would like to know what your thoughts are for the following:
I have 2 tables tb_serials and tb_temp_serials. The user scans in the serial number and it writes it to temp_serials, which gets displayed on reload in a table.
When he is done scanning he clicks finish and it copies the serials to the tb_serials and clears the tb_temp_serials.
I am positive this is not the right way for me to do it, and if there are more then one user scanning serials it cause an issues. Obviously i can't create 10 tb_temp_serials tables.
What would your suggestions be in this regards?
Any help would be most appreciated.
Thanks!
Adrian
I would like to know what your thoughts are for the following:
I have 2 tables tb_serials and tb_temp_serials. The user scans in the serial number and it writes it to temp_serials, which gets displayed on reload in a table.
When he is done scanning he clicks finish and it copies the serials to the tb_serials and clears the tb_temp_serials.
I am positive this is not the right way for me to do it, and if there are more then one user scanning serials it cause an issues. Obviously i can't create 10 tb_temp_serials tables.
What would your suggestions be in this regards?
Any help would be most appreciated.
Thanks!
Adrian