//connection information
$host = 'mysqlv101';
$user = 'simong_mc';
$pass = 'MChammertime22';
$db = 'mc_simong';
$conn = mysql_connect($host, $user, $pass);
//connection needs db name below
mysql_select_db("mc_simong", $conn);
// after the from is whatever table you are attempting to pull data from
$connstring = "SELECT * FROM MC WHERE biome LIKE '%grassland%' ";
$result = mysql_query($connstring);
?>
GRASSLAND AREAS OF PROCRASTANIA
//connection information
$host = 'mysqlv101';
$user = 'simong_mc';
$pass = 'MChammertime22';
$db = 'mc_simong';
$conn = mysql_connect($host, $user, $pass);
//connection needs db name below
mysql_select_db("mc_simong", $conn);
// after the from is whatever table you are attempting to pull data from
$connstring = "SELECT * FROM MC WHERE biome LIKE '%forest%' ";
$result = mysql_query($connstring);
?>
echo "
";
// after each bold is a column name so its appears organized
echo "";
echo "warp | ";
echo "cords | ";
echo "height | ";
echo "biome | ";
echo "desc | ";
echo "
";
while($nt=mysql_fetch_array($result)){
echo "";
// for each $nt has a correlated column name to display
echo "$nt[warp] | ";
echo "$nt[cords] | ";
echo "$nt[height] | ";
echo "$nt[biome] | ";
echo "$nt[desc] | ";
echo "
";
}
echo "
";
?>