I use dreamweaver, PHP and MYSQL.
I need some help and any is appreciated, I have alot of knowledge in html learnt from some college, little in php and none in mysql, I am self teaching php and mysql, so forgive me if the question is too easy. :)
Ok so I have a database with many tables, " Table A that is the main table which has some details in it (long_description, short_description, type ), a primary key and 4 foreign keys ( table B ID, Table C ID, Table D ID and Table E ID).
I have managed to display the data with all the tables joined to create 1 record.
but now I am stuck at trying to create a search, using a URL parameter passed between 2 pages using the get method.
The search page has a form, a drop down list populated by table B and the submit button. The URL parameter gets passed on with no problem, and I even see it on the url when I preview and test it.
I am trying to filter the results so that they show records that are related to a particular ID in table B and I have no Idea what syntax to use in the sql.
I have managed to get up to showing results of table A but I have no Idea on how to join the other tables to the results.
Hope that makes sense,
Can anyone Help??