help

[werkzeug]

Anyone willing to help me with W6D to make a website where people can search a town by their zip [postal] code ?

[steve.ledger]

You mean something like this?
► http://auspost.com.au/apps/postcode.html

(you can enter a postcode or town name)

[werkzeug]

EXACTLY! Can you help me Sledger?

[steve.ledger]

Do you have a database of postcodes and towns setup?
You'll need this so that searches can query the db.

[werkzeug]

Yes

[steve.ledger]

Which type?

[werkzeug]

M/s office excel 2003 and using Xara WD6 and just bought CoffeeCup

[steve.ledger]

.xls files are not valid on UNIX servers 'as is' though it may be possible to import an .xls into MySQL tables then set-up some .php scripting functions for your page search. Either way, you're going to need a programmer - it's not something you can just do in Xara.

[Soquili]

It has been a few years since I worked with MySQL. To import data from an Excel spreadsheet, it was easier to export from Excel as a CSV (Comma Separated Value) file and import that into MySQL.

What type of server will your site be hosted? If it is a Microsoft server you can use vbscript or jscript (javascript) on the server to access the Excel file, you will need a programmer to write the code for you.

If the server is Linux or Unix then follow Steve's advice and have a programmer write code to access MySQL.

[werkzeug]

I use Godaddy for most of my sites.