\n";
$conn = mysql_connect("luna.metalab.unc.edu", "gaston", "scotus77nip");
mysql_select_db ($db, $conn) or die ( "Could not select database $db");
$query = "SELECT * FROM object WHERE section = 'Community' ";
$resultHandle = mysql_query( $query, $conn ) or die ( "Could not get list");
/* generate the form */
$numRows = mysql_num_rows($resultHandle);
for ($i=0; $i <= $numRows; $i++) {
$row = mysql_fetch_row($resultHandle);
echo "$row[2] \n";
echo "$row[1] \n";
}
mysql_close($conn);
?> |
|