get_results($query);
if($result)
{
// while ($row = Mysql_fetch_array($result))
// while ($row = mysqli_fetch_array($result))
foreach($result as $key => $row)
{
$field_number = $row->field_number;
switch($field_number)
{
case 1.3:
$fname = $row->value;
break;
case 1.6:
$lname = $row->value;
break;
case 4:
$yachtclub = $row->value;
break;
case 5:
$boattype = $row->value;
break;
case 6:
$boatname = $row->value;
break;
case 7:
$boatlength = $row->value;
break;
case 8:
$dock = $row->value;
echo “
” . $lname . “, ” . $fname . “ |
” . $yachtclub . “ |
” . $boatname . “ |
” . $boattype . “ |
” . $boatlength . “ |
” . $dock . “ |
“;
break;
default:
break;
}
}
}
?>