I have several 'look-up' tables in my db for populating drop downs. These values are stored in my main table as numbers. When I display a record I select the name from the lookup table where the id is equal to the number stored in the main record, pretty standard stuff I should think.
Now I want to get all the data in the same query. Here is what I have tried...
SELECT * FROM Property, Prop_Status WHERE Property.Status = Prop_Status.Status_ID
I got no errors so I assume it must have worked but I don't know how to get the values. I use $row[0] to get the values usually, but what I need to know is what row number the Prop_Status table can be found at?? It has 2 feilds, ID and Title, and I want the title.
Many thanks, Mark
