kalpa wrote:I made a similar thing a few years ago that searched directly in the DB, that's not a good option.
Besides the ugly DB lookup my solution was similar to yours and have worked good for some years now.
I did that for a wholesale company to find retailers as well.
But...
...I kinda regret that it was map based instead, 'cause many of their retailers are tired of ending up in the bottom of the page or not getting enough attention in other ways.
Therefore the map option is better imo. If you are close to a retailer you'll probably select company by other criteria than only their name and have ..
// ;) Kalle
Im doing or right said, Im trying to do the exactly same thing you did a few years ago.
I have the customer list in an XML file that looks like this:
<ATERFORSALJARE>
<LANSKOD>18</LANSKOD>
<KONCERN>SH</KONCERN>
<NAMN>Materialmännen</NAMN>
<POSTADRESS1>Folkparksvägen 60</POSTADRESS1>
<POSTADRESS2>Rondellens Köpcenter</POSTADRESS2>
<POSTNR>59362</POSTNR>
<ORT>Västervik</ORT>
<LAND>Sverige</LAND>
<TEL>020-350 400</TEL>
<EPOST>info@materialmannen.se</EPOST>
<WEB>www.materialmannen.se</WEB>
</ATERFORSALJARE>
With an XSL file Im showing at the moment all the customer in a list sorted by name.
If a customer has a value in <KONCERN> the XSLT will show a picture depending on the value.
For example SH means Svenska Hem, so the picture will be Svenska Hems logotype.
But what I havent solved is to do different links to show different customers.
I want: LINK1 to show all customers that has <LANSKOD>01</LANSKOD>
I want: LINK2 to show all customers that has <LANSKOD>02</LANSKOD>
and so on...
I havent solved a so called supersearch. I want to add a search function that searches through the whole XML. So you can search all field at the same time.
Would be very greatful if someone could help me with this.
If someone has some time over, and maybe can help me through MSN:
george_makdesi@hotmail.com/George