|
|
Posted by Frankly on 07/17/06 22:07
"J.O. Aho" <user@example.net> wrote in message
news:4fo8qhF1jvtpeU1@individual.net...
> If you think you never will post it at more places than 10, then okey, but
> you can also create a new table where you save the apartmentid and the
> website where you posted the ad to, this way you can have more places to
> advertise at than ten (I hope I didn't misunderstand you here).
this new table will require an inner join to the Apartments table. ?
lets call it NewTable.
Select Apartments.ApartmentID, NewTable.ApartmentID,
from Apartments, NewTable
where Apartments.ApartmentID = NewTable.ApartmentID;
it seems to have worked.
i know its not much but i am pretty damn happy.
my first join.. i will remember it always :).
Frank
>
>
>> Website, to save space i think i will just make this a Varchar ( 40)
>> there is no need for this to be a link.
>
> If you have some frequent places where you post, then the site name may be
> enough and 40 would be okey for that (works for short URLs too).
>
>
>> Posted to - Varchar (20)i sometimes post the same add to more than 1
>> place or sometimes only 1. this one is confusing to me.
>
> Look at what I wrote a bit higher up in this post, if you choose to use
> the method I suggested, then you can skip this one. You can of course add
> more fields to the table I was thinking about, like date when posted on
> the site.
>
>
>> Edit link. Varchar (255)
>
> Not sure what this is, so I can't comment this.
>
>
>> Date posted. date 0000-00-00
>
> When you do the INSERT of the apartment to the table, instead of writing
> the current date as '2006-10-20', you can use the SQL function CURDATE()
> which will return the date.
>
> INSERT INTO table(date) VALUES(CURDATE());
>
>
>> Fee Disclosure. Varchar (70)will need 4 choices. but can put them in by
>> hand.
>> Posted by - will need choice of 2 of about (30) needs to be Name of agent
>> and name of firm.
>> Subject - Varchar (70) usually includes a brief discription of apartment
>> Comments. Varchar (255) about apartment -
>> MyContactinfo - Varchar (255) 2 choices this usually displays in the
>> same field as comments. i usually include a bit of html.
>> Email-
>>
>> Email, Posted by, MyContactInfo, I think INT can be used. 0 for me and
>> of course my wife can be number 1 :).
>> the realy tricky one for me is how can i disply where i posted to.
>> can i have something like 4 check boxes each box representing a different
>> website?
>
> Yes, you can do that and this can be done in quite many ways, the usual 4
> fields where you store 0 (not posted here) or 1 (posted on the website).
> You can also use one filed and use a binary way of thinking, one website
> is 1, next one is 2, third is 4 and the last is 8, 0 is the same as it's
> not posted at any of the websites, if the value is 5, then the site has
> been posted at website 1 and 3, but not at 2 and 4. This has the drawback
> that you need more PHP code to check up which sites has been posted at.
>
>
>> if i had no one to ask i would use enum for the FeeDisclosure. lol i
>> would have also used that for most of the fields :).
>> i guess i could also use INT for fee discloser but i think that is a
>> little tricky.
>> my choices for fee discloser are - the only thing i can think of is enum
>> or INT and have 5 choices.
>> No Broker fee.
>> Low Broker Fee.
>> Broker Fee Negotiable.
>> 15% broker fee. < hardly ever used but sometimes her boss wont except
>> less.
>> 1 Month Broker Fee.
>> all of them include a $40 credit check fee.
>
> Okey, INT(1) could be used here, where each of the options has one value.
> As I have said before, I'm not good at ENUM, so I won't say no or yes, but
> I know the INT(1) would work fine.
>
>
>> If i had my own place i would make them all 1 month fee. i think that is
>> very reasonable.
>
> Bosses can make a load of troubles :)
>
>
>
> //Aho
Navigation:
[Reply to this message]
|