Location: PHPKode > scripts > roundbase data interface > roundbase-data-interface/allresults.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <?php
 include ('config.php');
 include ('prefs.php');
 ?>
 
<html xmlns="http://www.w3.org/1999/xhtml">

	<head>
		<meta http-equiv="content-type" content="text/html;charset=utf-8" />
		<meta name="generator" content="Adobe GoLive" />
		<title><?php echo "$title" ?> | all results</title>
		<link href="style.css" rel="stylesheet" type="text/css" media="all" />
	</head>

	<body bgcolor="gray">
		<div class="default" align="center">
			<?php include "header.php"?>
			<h1>All Results</h1>
			<p><?php
$dbh=mysql_connect ("localhost", "$user", "$pass") or die ('I cannot connect to the database because: ' . mysql_error());
 mysql_select_db ("$database");
$query = 'select * from data order by id desc';
 $result = mysql_query($query);
 
while ($r = mysql_fetch_array($result))
{
 
 $fld1= $r["fld1"];
 $fld2= $r["fld2"];
 $fld3= $r["fld3"];
 $id= $r["id"];
  

 echo "			<table width=\"337\" border=\"1\" cellspacing=\"2\" cellpadding=\"0\">

 	<tr>
				<td colspan=\"4\" bgcolor=\"#09b6c1\"><font color=\"black\"> $fld1</font></td>
			</tr>
			<tr>
				<td bgcolor=\"#0981c1\" width=\"31\"><font color=\"black\">$id</font></td>
				<td colspan=\"3\" bgcolor=\"#0981c1\"><font color=\"black\">$fld2</font></td>
			</tr>
			<tr>
				<td colspan=\"4\" bgcolor=\"#0981c1\"><font color=\"black\">$fld3</font></td>
			</tr>
			
			</table>
			<p><hr>
			
					";
 }//end while
 
 ?><br>
			</p>
			<p></p>
		</div>
	</body>

</html>

Return current item: roundbase data interface