Wednesday, May 8, 2019

selection by array


Hello

Here I display : Call one query one time. Save its value in array. Fetch it whenever need it.

/*get stage types*/
$stgsql = "SELECT * FROM stage_t";
$stgrs  = mysql_query($stgsql);
$stageTypes=array();
while($rowStage=mysql_fetch_assoc($stgrs))
  $stageTypes[$rowStage[code]]=$rowStage[edesc];

echo  $todaysstage = $stageTypes[$row[todaysstage]];