Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [Andy] Two User Types? ... (plus misc)

Quote Reply
Re: [Andy] Two User Types? ... (plus misc) In reply to
Hi Andy, thanks for the reply again.

Quote:
Sure, that could work. I would use a SELECT field (no ENUM), and then have text values + the 0/1 values that get stored in trhe DB (just a bit nicer in terms of DB speed, especially if your user DB gets large)

Are you suggesting here a CHAR column with a column width of 1, and just insert either a 0 or 1 depending on whether the user type being submitted is an Advertiser or not?

I'm not sure if CHAR or TINYINT would be a better choice in this case?
Matt G
Subject Author Views Date
Thread Two User Types? ... (plus misc) Matt G 3267 Apr 21, 2012, 2:59 PM
Thread Re: [Matt G] Two User Types? ... (plus misc)
Andy 3310 Apr 21, 2012, 11:58 PM
Thread Re: [Andy] Two User Types? ... (plus misc)
Matt G 3211 Apr 22, 2012, 10:59 AM
Thread Re: [Matt G] Two User Types? ... (plus misc)
Andy 3173 Apr 23, 2012, 4:45 AM
Thread Re: [Andy] Two User Types? ... (plus misc)
Matt G 3113 Apr 25, 2012, 6:56 AM
Thread Re: [Matt G] Two User Types? ... (plus misc)
Andy 3068 Apr 26, 2012, 2:24 AM
Thread Re: [Andy] Two User Types? ... (plus misc)
Matt G 3017 Apr 28, 2012, 2:59 PM
Post Re: [Matt G] Two User Types? ... (plus misc)
Andy 3003 Apr 29, 2012, 12:54 AM