RE: [PHP] serialize

From: Date: Mon, 26 Sep 2005 14:20:50 +0000
Subject: RE: [PHP] serialize
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-223192@lists.php.net to get a copy of this message
> murray... > > it may have been helpful to the guy to also give him an idea of your tbl > structure. i think you're talking about something like: > tbl schema > > EvalTBL > -id > -UserID > -ScoreTypeID > > ScoreTBL > -id > -ScoreType > > table ScoreType could/would have as many different categorites as > required. > table EvalType would have a scoreTypeID (from the ScoreTBL) for each > userID. > each user could have multiple scoreTypes in the EvalTBL... Hi bruce, That would have been an even more normalized representation of the table(s), yes. For the purposes of demonstrating a state of normalization that still allowed the OP to maintain a single table, my structure in that post was: Scores -ScoredThingID -scoretype -score I would personally have implemented a structure similar to the one you outlined, but posted with the idea of "first things first". That's why I included a link to a tutorial on normalization and suggested Googling on the topic as well, for further reading. Still and all, it's helpful of you to clarify. Much warmth, Murray --- "Lost in thought..." http://www.planetthoughtful.org

« previous php.general (#223192) next »