Am having lots of questions pop up, so am posting them as I think them..hope you don't mind
Having read that ideally, you should not use SELECT * and specify which columns you want instead, e.g.
I have successfully changed all my coding accordingly with one exception:
Any ideas how I could work this one? Or am I allowed to occasionally have an exception to the rule?
Having read that ideally, you should not use SELECT * and specify which columns you want instead, e.g.
PHP:
SELECT column1, column2 FROM...
I have successfully changed all my coding accordingly with one exception:
PHP:
while ($gptp <=5)
{
$gptplan="plan".$gptp;
$gptget = mysql_query("SELECT * FROM $gptplan
WHERE userid = '$gptuser' AND email = '$gptemail' LIMIT 1");
while($row = mysql_fetch_array($gptget))
{
$_SESSION[plantot][$gptp]=$row[plantot];
$_SESSION[plannew][$gptp]=$row[plannew];
$gptlvl=1;
while ($gptlvl <=9)
{
$gpttot="lvl".$gptlvl."tot";
$gptnew="lvl".$gptlvl."new";
$_SESSION[gpttot][$gptp][$gptlvl]=$row[$gpttot];
$_SESSION[gptnew][$gptp][$gptlvl]=$row[$gptnew];
$gptlvl++;
}
}
$gptp++;
}
Any ideas how I could work this one? Or am I allowed to occasionally have an exception to the rule?