Hi all,
Would really appreciate as much help as possible. I have two tables in a database to store data.
Table1 detail
Table 2 description
I need to display the results of detail table on a page and if the table has a decription as well that will also need to be displayed. I have managed to run the query, but if there is no records in the description table relationing to the detail table then the detail table will not display the results, confussed yet!!
eg:
do { (repeating region)
detail table. details name
detail table. notes
descriptiontable. description name
descriptiontable. description notes
} while etc etc
query as follows
SELECT * FROM jobcard_index, jobcard_detail, jobcard_description WHERE jobcard_description.detail_id = jobcard_detail.detail_id AND jobcard_description.page_number = jobcard_detail.page_number
AND jobcard_detail.jobcard_id = jobcard_index.jobcard_id AND jobcard_index.jobcard_id = '$jobcard_id'";
Really hope someone can help, i really appreciate any help advice given
Kind Regards,
Steven
