Anyone willing to help me with W6D to make a website where people can search a town by their zip [postal] code ? ;))
Printable View
Anyone willing to help me with W6D to make a website where people can search a town by their zip [postal] code ? ;))
You mean something like this?
► http://auspost.com.au/apps/postcode.html
(you can enter a postcode or town name)
EXACTLY! Can you help me Sledger?
Do you have a database of postcodes and towns setup?
You'll need this so that searches can query the db.
Yes
Which type?
M/s office excel 2003 and using Xara WD6 and just bought CoffeeCup
.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.
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.
I use Godaddy for most of my sites.
So you are thinking of a form for a user to input a query which google uses to search your excel spreadsheet and somehow print the result to a coffee cup widget?
I think you better get the help of a programmer.