Posted by Frankly on 05/05/06 20:47

"J.O. Aho" <user@example.net> wrote in message
news:4but6tF13ulrrU1@individual.net...
>> wow that is great thank you.
>
> Thats how things can be done here and it has worked well before.
> sorry that I missed your posts, been busy on my end.

( Before you reply to any questions I have asked in in this reply, let me
first apply what you did say in
PHPmyAdmin and MySQL) I dont want to abuse your help or get to ahead of
myself.

No need to say you are sorry. Push me and it will mean nothing.
Push my wife, I wont be able to control myself.
Help me and I will be thankful, Help my wife I wont be able to thank you
enough.
I am sorry that I made 3 very big posts the other day, i think it only
confused things. for now on i will take notes during the day of the things I
am not sure of and just edit as needed..


>
>
>> As far as the code goes, I am thinking you mean (row Source type and Row
>> Source)
>
> Raw code, your php script.

oo that code.
I first came here when I first relized that using PHP myadmin as the GUI :)
for mySQL was the most reliable of my choices. I gave it a very hard shot
and thought it would be better to first learn more about relations using MS
Access. At one point I was thinking and still not sure if MS would be a
better choice for someone with my limited knowledge in computers. I still
have a lot to learn no matter what way i choose.
I know just enough about the open source products to repect them but never
knew enough to concider formyself. I am going to try MySQL once again with
the table structure you have recommended.
no matter what way i go i feel that PHP is in my future. I am also
wondering about ColdFusion and even ASP.net
however at this point I wonder if these are things I can actually learn in
order to do what I want.
in the end it has to be user friendly enough so that even my wife can use it
on her own. she knows much less than I do. I think she has only checked
email not even 100 times. reliability is also important, a curropt database
wont do her any good. I first came here on topic but still asked questions
even when i went ( puts hand over mouth and mubbles ) Access Xp. I figured
i would try and still post questions here. sooo to make a long story
short... PHP.. I didnt use it yet. 99.9% was done via the wizards in
Access.



>
>
>> once I know I have the table structure right, I will know if problems
>> are in what I am trying to.
>
> You can make relations in the following way
>
> Management table:
> ManagementID
> Contact
> Phone
> Address
> Notes
>
> Buildings table:
> BuildingID
> Building
> Street
> CrossStreetA
> CrossStreetB
> CommonOutdoorSpace
> BuildingContact
> ContactPhone
> BuildingNote
> Area
> ZipCode
>
> RelationManagementBuilding table:
> ManagementID
> BuildingID
>
> It's IMHO easier to join with this method and you can have multiple
> relations. You can have one row in Management table to be linked to more
> than one Building, which in it's case can be linked to many Apartments.
> Your setup limits a one to one relation all the time.

I am wondering if i should create the relation to the apartments table via
the RelationManagementBuilding Table
or to the Buildings table.

>
> > I would also like to be able to add a Area Table and ZipCode Table or
> > separate tables.
>> Not yet but once I start to look into queries I would like to
>> put the Area to a building that it also brings the zipcode.
>
> One way is to create a ZipTable were you have
>
> ZipTable:
> ZipCode
> Area
>
> you can then in theory drop the area column in the buildings table and use
> JOIN http://dev.mysql.com/doc/refman/5.0/en/join.html to put together the
> Building table with the ZipTable and you would get the correct area (as
> long as the right zip code has been entered).
>
> But I think you will always want to see the which area the building is in,
> then you still want to make that Area column, as it will speed up searches
> (join takes time, more the more rows you have inb the both tables).

thank you.
I will let you know how this turns out in mysql which i will be starting
again
later today.

>
>
> > Even tho my wife has begged me to step back a few days. I find I cant I
> > feel like the Blues Brothers and I am on a mission from God. J
> > I love a challenge and the worst part of this is not knowing if this is
> > something I can teach myself.
> > Well my wife is right I have become obsessed with this. It is very
> > important to me.
>
> I do recognize myself there, been times when I spent up most of the night
> working on some project. But keep in mind, spend time with your wife or in
> the worst case you may not have one and then there wouldn't be any point
> with this project.

> //Aho

Not likely my wife will leave me :). however I was treating her very
badly.
when ever she would try to talk I would snap at her because she broke my
concentration.
even when i walked away from the computer i was thinking in a way that would
not allow conversation and for a few nights it was all i dreamed about.
my biggest worry is - is this actually something I can do in a timely
manner. I respect it enough to know
this is going to be the hardest thing I have ever learned. I may even stay
away from it today because I am still recovering. I guess the weakness I
felt was because I was working myself into a nervous breakdown.
thank you again.. I may stay away from it again today but I am also very
curious about how the little I learned will help me in MySQL.

TTYS
Frank

[Back to original message]