Hi
I'm trying to write a script that does a mysql_query to extract the
contents of a field called "makes" in a database. The table is called
dealers. Each recordset contains information about individual dealers
including the company name ("company") and the makes they stock
("makes").
The "makes" field contains a string, for example:
Bugatti,Ford,Toyota,Renault,Vauxhall
What I want to do is create a drop down list of all the makes listed
in this field and remove any duplicates. But this is where I get
stuck.
I can list the "makes" field no problem in a drop down list, but
separating each name in the field so that it appears as a separate
item in the drop down list is defeating me. Of course the next stage
would be to remove duplicates.
I suspect the answer is in the manipulation of arrays, can anyone
help or point me to resources that would help?
TIA
Richard
