Two parts to this project
One
I have been using mod_rewrite on my sites reading off one main table. This is controlled through code in index.php
I now want to read from a second table in addition to the first table.
I want the index page code edited to allow this.
Attached is the index.php page and the htaccess code.
Two
I also want code to query two tables, and give a list of the towns where properties are situated and the number of properties.
The list of towns in the table is 140. I want to display only those towns where there are properties ( varTown in the table and the id of the town) and the number count for each town
eg
London (23)
Leeds (10)
manchester (55)