Hi sorry for yet another silly question but I’m trying to create a business directory which stores shops contact information. I would like to build a search facility so users can pull back shops based on shop type, like ‘electrical’ or ‘book shops’ etc. I have created three tables as follows but am unsure of the code needed to implement such a drop-down search tool, I would again really appreciate any assistance with this my e-mail address is chris@forscutt.com (cc to) cforscutt@hotmail.com

-------------------------
street
-------------------------
id
shop_model
shop_name
shop_short_descr
shop_long_descr
shop_image
shop_opening_hours
shop_address
shop_telephone
shop_fax

-------------------------
street_shop_link
-------------------------
street_shop_link_id
shop_id
street_shop_type_id

-------------------------
street_shop_type
-------------------------
street_shop_type_id
street_shop_type_descr

I have tried the following but I must be going wrong somewhere as its returns an error #1064 - You have an error in your SQL syntax:

Select street.shop_name, street_shop_type. street_shop_type_descr from (street_shop_link join street on street_shop_type.shop_id = street.id) join street_shop_type on street_shop_type. street_shop_type_id = street_shop_link.street_shop_type_id where street_shop_type. street_shop_type_id= ‘1'

any ideas what i'm doing wrong, I would greatfully apreciate any help.

I got your email, bud. I am currently working on something, but should be finished very soon and will look at your problem.

Steve.

I really appreciate it Gaffer ta - your the man!

Email Sent with code.

Steve