";
print mysql_connect_error();
print "
";
}
//else {
//print "connected
";
//}
mysql_select_db('jnovenstein');
$query="SELECT* FROM fieldnewest4";
$result=mysql_query($query);
$error=mysql_error();
if($error) {
print "query $query
lead to error $error
";
exit;
}
print "\n";
// fields in the database
$fields=array('company','city','state') ;
print "";
foreach($fields As $field) {
print "$field | ";
}
print "
\n";
while($columns=mysql_fetch_array($result)
print"";
foreach($fields As $field) {
print "$columns[$field] | ";
}
print "
\n";
print "
"
?>