PaperCamp: No Marshmallows, Just Term Papers

Program

Submitted by: Submitted by potog619

Views: 489

Words: 341

Pages: 2

Category: Science and Technology

Date Submitted: 09/29/2013 05:35 PM

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Core of the College List .php file</title>

</head>

<body>

<?php

$DBConnect = mysql_connect('localhost','root','');

if (!$DBConnect) {

die(mysql_error());

}

if (!mysql_select_db('university', $DBConnect)) {

die(mysql_error());

}

else {

$SQLQuery = "select * from college";

$result = mysql_query($SQLQuery, $DBConnect);

$numrows = mysql_num_rows($result);

if ($numrows > 0) {

LIST OF COLLEGES

<tr>

<td>Acronym</td>

<td>Location</td>

</tr>

<?php

while ($row = mysql_fetch_assoc($result)) {

print "<tr>";

foreach ($row as $field_name => $field_value) {

print "<td>$field_value</td>";

}

print "</tr>";

}

} //end of if ($numrows > 0)

else { //if $numrows == 0

echo 'SORRY, there are no College records to display.';

}

}...

View Full Essay