This is the last thing and I believe I will have everything the way I want. Again, you can add this to premium ticket.
The below mysql statement only displays the columns and data that are different (it's joining them), But I want to select (display) ALL columns from both tables with the product data, not only the different ones. (Once I get this working I can do for all 23 tables).
(fyi - The main table with the persons name, address, etc. is called quote_request, then the other tables that hold the info on the product they are requesting a quote on all have a suffx (e.g. quote_request_cs and quote_request_ir))
$WADAquote_request_all->setQuery("SELECT qr.quote_id_person, cs.*, ir.*
FROM quote_request AS qr
LEFT JOIN quote_request_cs AS cs ON
qr.quote_id_person = cs.quote_id_person
LEFT JOIN quote_request_ir AS ir ON
qr.quote_id_person = ir.quote_id_person
WHERE qr.quote_id_person = '" . $quoteid . "'");
The tables have different amt of column number with some similar names and some different. They are in fact different tables.
Thank you.
