I now have a bit more if anyone can help me.. I need to combine an entire row to make it display the whole name and address of the customer.. but all the information is in a row called value. I can get it to display each bit of information but it doesn't group the information from the value column. Here is the mySQL that I have:
SELECT value,name FROM wp_wpsc_submited_form_data
value is from the form_data table and name is from the variation_values table. The variation_values table is fine, its just the form_data table that I need the value column to be combined.
I've tried the GROUP_CONCAT command, but it doesn't work..