Read a MySQL Database and load array of values

  $query="SELECT * FROM foodmenu ORDER BY foodseq";
  $result=mysql_query($query) or
    die( "Unable to get query result!<Br>$query<Br>" . mysql_error());
  $num=mysql_numrows($result) or
    die( "1 unable to get numrows from result" . mysql_error());

  // echo "NUM: $num<Br>";

  $j=0;
  while ($j < $num) {
    $vid[$j]        = mysql_result($result,$j,"id");
    $vfoodseq[$j]   = mysql_result($result,$j,"foodseq");
    $vfoodhdr[$j]   = mysql_result($result,$j,"foodhdr");
    $vfoodprice[$j] = mysql_result($result,$j,"foodprice");
    $vfooditem[$j]  = mysql_result($result,$j,"fooditem");

    ++$j;
    }

  $query="SELECT * FROM Mbr_Main WHERE (Mbr_Main_Rec_Idc < '4') 
                                 ORDER BY Mbr_Main_Div, 
                                          Mbr_Main_Min_Game_Idc DESC,
                                          Mbr_Main_Average DESC";

Close Window