Anyone willing to help me with W6D to make a website where people can search a town by their zip [postal] code ?
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
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.
Last edited by Soquili; 12 October 2010 at 11:18 AM.
Soquili
a.k.a. Bill Taylor
Bill is no longer with us. He died on 10 Dec 2012. We remember him always.
My TG Album
Last XaReg update
I use Godaddy for most of my sites.
Bookmarks