Edit Index To Read 2 Tables And Use Mod_rewrite Plus List

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)

Leave a Reply

Your email address will not be published. Required fields are marked *