Cannot connect");
}
mysql_select_db("alumni");
$qry="SELECT Brick_ID, Inscription FROM bricks3 WHERE Inscription like '%jones%' ";
$result = mysql_query($qry, $connect);
if (!$result) {
die ("Error in accessing the database or querying it
");
}
$count=0;
while ($row = mysql_fetch_row($result)) {
$count++; #add 1 to the $count variable
print "";
foreach ($row as $field){
print "$field ";
}
print "
\n";
}
print "Total number of records fetched = $count
\n";
mysql_close($connect);
?>