Planning on rewriting a simple availability chart that shows the availability of a product on a weekly basis.
Currently, it is setup as a single row, with the number of weeks as a each as column.
ID COL1 COL 2 COL3
Would it be better to flip it around and have two/three columns and a larger number of rows?
ID WEEK STATUS
The code to pull it out is pretty awful too (not mine):
$sqlquery = "SELECT april3, april10, april17 ... FROM avails";
$result = mysql_query($sqlquery);
$number = mysql_num_rows($result);
$i = 0;
while ($number > $i)
$april3 = mysql_result($result, $i, "april3");
$april10 = mysql_result($result, $i, "april10");
$april17 = mysql_result($result, $i, "april17");
Makes it easier to calculate minima, maxima, averages, standard deviations, etc.