Retrieving multiple towns from a database

[mrw2020]

Hi I have a retailers database, and I would like to retrieve multiple towns using php, the table name is retailers and the layout is as follows:

ret_name
add1
add2
ret_town
ret_county

can anyone suggest the php/sql code to use for this?

Any help would be greatly appreciated.

[NogDog]

Not real sure what you're asking. What do you mean by wanting to retrieve multiple towns? What is the criteria that decides which towns to select?

[mrw2020]

Sorry I didn't phrase my question correctly, I'm trying to find a way of retrieving records from a database based on the town where the retailer is. For example a visitor would click 'London' and a list of retailers would be displayed - in fact I think I've answered my own question use a 'WHERE' clause!

Obviously I'm having a senior moment :o