\n"; echo "\n"; echo " gbff test\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; echo "\n"; // -- show tables -- $query = "SHOW TABLES"; $result = mysql_query($query); if (!$result) { echo 'Invalid query: ' . mysql_error() . "
\n"; } echo "\n"; echo "Results for: $query :-\n"; echo "\n"; html_result($result); mysql_free_result($result); // -- $query = "SELECT * FROM {$dbt_equipment}"; $result = mysql_query($query); if (!$result) { echo 'Invalid query: ' . mysql_error() . "
\n"; } else { echo "\n"; echo "Results for: $query :-\n"; echo "\n"; html_result($result); mysql_free_result($result); } // -- $query = "SELECT * FROM {$dbt_bookings}"; $result = mysql_query($query); if (!$result) { echo 'Invalid query: ' . mysql_error() . "
\n"; } else { echo "\n"; echo "Results for: $query :-\n"; echo "\n"; html_result($result); mysql_free_result($result); } // -- $query = "SELECT * FROM {$dbt_booking_list}"; $result = mysql_query($query); if (!$result) { echo 'Invalid query: ' . mysql_error() . "
\n"; } else { echo "\n"; echo "Results for: $query :-\n"; echo "\n"; html_result($result); mysql_free_result($result); } // -- /* write lock for tables mysql> LOCK TABLES trans READ, customer WRITE; mysql> SELECT SUM(value) FROM trans WHERE customer_id=some_id; mysql> UPDATE customer -> SET total_value=sum_from_previous_statement -> WHERE customer_id=some_id; mysql> UNLOCK TABLES; write lock = stops reading from other threads */ // -- reload button -- echo "
\n"; echo "

\n"; echo "\n"; echo "    "; echo "\n"; echo "    "; echo "\n"; echo "    "; echo "

\n"; echo "
\n"; // ---- echo "\n"; echo "\n"; // ---- return(0); ?>