// connection information $hostName = "dbm1.itc.virginia.edu"; $userName = "dee2b"; $password = "\$x.\$y.x"; $dbName = "dee2b_presidents"; // make connection to database mysql_connect($hostName, $userName, $password) or exit("Unable to connect to host $hostName"); mysql_select_db($dbName) or exit("Database $dbName does not exist on $hostName"); // Run a SQL Query // $result = mysql_query("SELECT * FROM presidents"); // to select everyone $result = mysql_query("SELECT lastname, firstname FROM presidents " . "WHERE college='William and Mary' ORDER BY lastname"); // Determine the number of rows $numrows = mysql_num_rows($result); $numcols = mysql_num_fields($result); // print the results print "
" . mysql_field_name ($result, $k) . " | "; } print "" . mysql_result ($result, $i, $j) . " | "; } print ""; } print "
---|