> So, I had a crazy (and probably dumb) idea. :) > > I'm setting up a calendar of events, with a full db back-end. > The end result is to have the events pulled like event.php?id=1000 > Straight forward. > > but then, i go thinking.. "Wouldn't it be more productive, and > meaningful, if the id actually meant something?" > > Here's what i'm thinking-- event.php?id=yyyymmddhhmm_(and some 1,2,3 or > a,b,c character here if there is more than one at that given day/time) > > with this syntax, I can easily mod-rewrite it into a nice and clean > event/yyyy/mm/dd/hh/mm/index.php > > > What's your thoughts on using this style, vs an auto-increment id field? > Would you anticipate any problems?
Although you can do this, the act of adding a letter makes your primary key field less efficient than an integer field. Indexing the field could help. The normal rule of thumb is that you shouldn't put information that is easily recognizable in the URL or POST. Ultimately, it depends on the nature of your application. If it is a free calendar and you don't care who sees which events, then perhaps you can do this effectively. James _____ James D. Keeline http://www.Keeline.com http://www.Keeline.com/articles http://Stratemeyer.org http://www.Keeline.com/TSCollection http://www.ITeachPHP.com -- Free Computer Classes: Linux, PHP, etc. Summer Semester Begins Jun 20 -- New Classes Start Every Few Weeks. ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hkg339q/M=362131.6882499.7825260.1510227/D=groups/S=1705005703:TM/Y=YAHOO/EXP=1123096958/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
