Posted by Frankly on 06/10/06 16:57

"J.O. Aho" <user@example.net> wrote in message
news:4f09geF1gcqe8U1@individual.net...
> Frankly wrote:
>>>> I tried this in Access with out any luck. i was able to create a combo
>>>> box in a form with fields for Area and Zipcode.. however when i
>>>> selected the Area it wouldnt automatically bring the zip code. in
>>>> other forms i was able to include fields from other talbes that would
>>>> get filled according to a selection i made in a combo box.
>>> This requires some javascript coding too, if you want the zip code box
>>> to be automatically filled when you entered the area. Otherwise if you
>>> allow people to leave the box empty, you can let the receiving php page
>>> to fetch the zip code (keep in mind that an area may have more than one
>>> zip code, so it's really better to do it the other way around, fill the
>>> zip code and let the php script fetch the area name from the database
>>> and then save it into the row).
> >
>> I am not sure how i would create this table.
>
> ZipTable
> ZipCode AreaName


I thought a table like this would create dupes.
if i understand this correctly I could put multiple zip codes in a single
column :).


>
>> I guess allowing null would let some records have more zip codes than
>> others.
>
> No nulls, always a zip code and the area name, otherwise you get troubles.


i remember reading something that showed me how... I could help protect
myself by making it so
that I cant put an apartment, unless there is a building, and cant put a
building unless there is a management.
so the same thing for areas and zipcodes.

>> So it might be better if i insert these things manually. I know it would
>> allow for more errors but even with out doing that the amount of help I
>> will need is more than i ever expected getting.
>
> I think you can get a list from USPS, at least SP does provide such for
> free, then just make a small php script that reads the file one line at
> the time and saves the data to the sql database, don't take long time for
> 80000 zip codes to be saved. The down side with this is that you need to
> keep the list updated, at least here you may get a few changes an year

I have already done - Managements, Buildings and apartments tables today.
i guess this script will be in the form I create later on for inputing new
records.
what I had planned for today was to build all the tables, give my best shot
at making relations,
and input some records. then start learning how to make those records show
on my web site.
after that start working on those kinds of forms.
Does that sound like a good plan?


>
>
>> but then again when ever i did look to learn these things in the past i
>> never had any one to help explain
>> the explainations I didnt understand. I guess I can try and if need be
>> just add a Area and Zip code field to the buildings table later on :)..
>> yep thats the ticket.
>
> Here you can do two different things, just save the zip code, you can then
> joint the buildings table with the zip table, the draw back to do this is
> that the more zip codes and buildings you have, the longer time it will
> take to make the join.
> The faster way is to store both area and zip code in the building table,
> but still allow only the user (your wife?) to type the zip code in the
> form for saving the building to the database, in your php script you get
> the area name from the zip table, and then save this name to the building
> table, this way you always have the same spelling on the areas. I know
> here that sometimes people uses ' ' (space) or '-' (hyphen) on names that
> is "two" parted as 'Los Angeles' which could be written badly as
> 'Los-Angeles'.

ok, zipe code and area fields will be in the buildlings table. I guess I
will understand
this more once i start working on those forms :).

>
>
>> time to start building :).
>> i did search for my web again today and it now says.
>> Coming Soon.. this is the home of a future MySQL Hosting Website.. :).
>
> Good that it goes forward, I hope it won't take those 14 days as the
> support first said, it feels all to slow IMHO.
>
> Good luck with your building :)
>
>
>
> //Aho

While i do feel a bit lost with this new admin tool. I do believe in the
long run I will
be able to do more while asking less questions. to tell you the truth if
"I" get this thing done
I dont understand why anyone would limit them selves to MS. I am still a
bit nervous about it. I see
even Strawberry is asking questions on how to do things. back to work.

Frank

[Back to original message]