webform module to custom table
I have created (outside of drupal) a simple webform using html and a php file to post data to a simple 3 table relational database:
table1 SongID ¦ Song
table2 PerfID ¦ Performer
table3 Song ID ¦ PerfID
I can do the queries on these tables within drupal by having a page with some php code in them.
I was just wondering the best way to do the form that populates the database.
The webform module looks excellent - would the best way of using this be to submit the data to a page that extracts the post data and populates my tables ?
(the webform_submitted_data table hass all the data, but not in the 3 table format I need for diplaying the queries)
(I also tried using CCK and Views, but ran into some problems with Node reference fields not being sortable)
