Thanks to al that repsonded and helped out. i dicovered that the form itself
was not quite right and not posting the variables doh anmy way that is now fixed
all but some cosmetics :)
so the problem now returns to the query in companies.php
if someone can have a little look and I am sure this wi
I have a query that is extracting records from a MySQL DB at the moment the
query is just pulling 'all' records and not the selected records from a drop
down :(
I am using php too.
the query I have is this:
$result=mysql_query('select distinct items.* from items,city,category where
items.CityID=