mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found. " . $dbuser);

$mainsection="Orders"; //The name of the table where web links are stored

$query1='SELECT * FROM `Orders` WHERE `warehouselocation`Like \'%j%\''
        . ' ORDER BY `Orderdate`';
$result = mysql_db_query($dbname, $query1) or die("Failed Query of " . $query1);  //do the query
while($thisrow=mysql_fetch_row($result))
{
  $i=0;
  while ($i < mysql_num_fields($result))
  {
    $field_name=mysql_fetch_field($result, $i);
    echo $thisrow[$i] . " ";  //Display all the fields on one line
    $i++;
  }
echo </br>"; //put a break after each database entry
}