hotcode - $HOTEL_CODE\n"); echo("

\n"); echo("\n"); $sql->Query("Select LONG_NAME, HOTEL_URL, HOTEL_CODE, SINGLE_RATE, TWIN_RATE, SINGLE_RATE_DX, TWIN_RATE_DX from HOTELS_BASE order by LONG_NAME"); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $f1 = $sql->data[0]; $f2 = $sql->data[1]; $f3 = $sql->data[2]; $f4 = $sql->data[3]; $f5 = $sql->data[4]; $f6 = $sql->data[5]; $f7 = $sql->data[6]; echo("\n"); } echo("
HOTEL NAME
$f1
\n"); ?>