I have 2 mysql tables (request and admin part)for one form written in php. now i need to have one. How can i merge these 2 tables into one (they both use the same ID numbers)without losing any data. thank you in advance
pull all of the data from one table with a SELECT statement and iterate thru the result writing to the other table using the common id in your WHERE clause of the UPDATE statement.
