<?php
$user="";
$password="";
$database="";
mysql_connect(localhost,$user,$password);
 
@mysql_select_db($database) or die( "Unable to select database");
 
$query="SELECT * FROM law_projects";
$result=mysql_query($query);
 
$num=mysql_numrows($result);
 
mysql_close();
 
 
echo "<b><center>Database Output</center></b><br><br>";
 
$i=0;
while ($i < $num) {
 
$city=mysql_result($result,$i,"city");
 
echo "<b>$city</b><br>";
 
$i++;
}
 
?>