3 mysql tables => 1

[h34rt]

Ok, I wrote this survey in php and it posts the results in 3 different mysql tables, survey_radio, survey_check, and survey_text. When a survey is submitted, it autoincrements the 'id' column at the same time for all 3, so id #45 (for example) for all 3 tables were posted by the same person. What i want to do is somehow merge the 3 tables and their data into 1 large table (it will make sorting a lot easier). i'm not really sure how to go about doing this, but phpmyadmin is installed on the server.

thanks =]

-h34rt

[LordShryku]

Something like this should work. It'll be best to specify the fields so you don't have duplicate ID fields

CREATE TABLE surveys AS
   SELECT sr.id,
          sr.field1, 
          sr.field2, 
          sr.field3,
          sc.field1,
          sc.field2,
          sc.field3,
          st.field1,
          st.field2,
          st.field3
   FROM   survey_radio sr, survey_check sc, survey_text st
   WHERE  sr.id = sc.id
   AND    sc.id = st.id

[h34rt]

========================
when you say
sr.field1
sr.field2 etc...

so you mean survey_radio.field1?

Oh nevermind, I see now

[h34rt]

Thank you so much, it worked perfectly.

-h34rt