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