[01:25] <dmcglone> Hi everyone
[01:26] <BiosElement> unHi dmcglone
[01:26] <dmcglone> what's up?
[01:26] <dmcglone> anyone good with database design?
[01:26] <BiosElement> Eh, maybe. haha
[01:27] <Cheri703> Don't forget daylight savings time!
[01:27] <dmcglone> I'm just fooling around with techniques on paging
[01:28] <dmcglone> was wondering if I should number the pages in the DB or just go by the "title" of the page
[01:28] <BiosElement> dmcglone, As in number each db entry? Or tag 15 entries with 'page5'?
[01:30] <dmcglone> more like putting a number to each db entry, besides the primary key ID
[01:31] <dmcglone> for instance the db would look something like this:
[01:31] <dmcglone> ID | page | description
[01:31] <BiosElement> Sounds like you're over-thinking it maybe.
[01:31] <dmcglone> and when called, go by the page number to get the description
[01:32] <dmcglone> I think I am too
[01:32] <BiosElement> I'm not aware of any db design that actually does that.
[01:33] <dmcglone> say for instance I put in the db ID 1 | page index | description bla bla bla on the page
[01:33] <dmcglone> wait a second, that wasn't correct
[01:34] <dmcglone> more like: ID 1 | page 1 | description bla bla bla text on page
[01:34] <BiosElement> You think too hard :P
[01:35] <dmcglone> I usually pull from the DB by title
[01:35] <dmcglone> I was playing around today and was trying new techniques
[01:36] <BiosElement> You may have a good idea, but I think it's probably more complex then it's worth.
[01:36] <dmcglone> and I pull the content for that page based on the page title
[01:37] <dmcglone> it's pretty much the way all the CMS's do it
[01:38] <dmcglone> I can't use the actual ID because it may not match up with the page title
[01:40] <dmcglone> I've even used case statements for page display :-)
[01:40] <dmcglone> huh, matter of fact I've used if else to display them too
[01:43] <dmcglone> is google sucking bad or what? I do a search and get a complete blank page
[01:47] <dmcglone> BiosElement: check this out, I wrote this about 5 years ago, simple function to get the page number from the db and display it's contents http://pastebin.com/5nwXPHLV
[01:48] <BiosElement> Mmm Ahh cool
[01:48] <dmcglone> with that code, I could enter everything for the page into a db and give that page a number and it would automagically generate that page
[01:51] <dmcglone> Oh the power of PHP ;-)
[01:54] <BiosElement> lol, I bet I could do it in python easier ;)
[01:54]  * Cheri703 watches yet another python / php pissing match
[01:55] <Cheri703> :D
[01:56] <dmcglone> bet? you don't sound so confident ;-)
[01:56] <dmcglone> lol Cheri703
[01:56] <Cheri703> put them on the table and measure already!
[01:58] <dmcglone> haha
[01:59] <dmcglone> I might break the table :-/
[02:00] <dmcglone> he's awful quiet, he's probably googling how to write paging methods for python
[02:00] <dmcglone> lol
[02:02] <dmcglone> I got another one for ya, that doesn't use a DB. I'll post it on PB for you to droooooooool over... LOL
[02:03] <dmcglone> drool on this: http://pastebin.com/Q3ZXQk57
[02:09] <dmcglone> Ah come on dude, you gotta drop kick me or something, just give me a sign... lol
[02:09] <dmcglone> and no I don't mean the middle finger haha
[02:12] <BiosElement> lol, sorry. Neck deep in auth code atm
[02:13] <Cheri703> can I just say for the record: SeaQuest is RIDICULOUS
[02:19] <dmcglone1> whats seaquest?
[02:19] <dmcglone1> a game?
[02:19] <dmcglone1> auth code in pearl? ;-)
[02:19] <Cheri703> 90's sci-fi tv show
[02:22] <dmcglone1> Oh ok
[02:23] <dmcglone1> I'm watching "I almost got away with it"
[02:24] <dmcglone1> getting ready to get my midnight snack. Cereal :-D
[02:26] <dmcglone1> shredded wheat anyone?
[02:40] <dmcglone1> well I'm off to bed :-)
[02:40] <dmcglone1> g'night everyone
[06:01] <BiosElement> Folks nextdoor want to run up and down the stairs all night and bang things around...apparently tonight's a free loud music night! ^_^
[23:57] <BiosElement> Yay for long as hell day tomorrow