<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head><body>
<?// Connect database.
mysql_connect("localhost","root","password");
mysql_select_db("tutorial");// Get data records from table.
$result=mysql_query("select * from name_list order by id asc");
?>
mysql_connect("localhost","root","password");
mysql_select_db("tutorial");// Get data records from table.
$result=mysql_query("select * from name_list order by id asc");
?>
<table border="1">
<tr>
<td bgcolor="#FF9900"><strong>No.</strong></td>
<td bgcolor="#FF9900"><strong>Company</strong></td>
</tr>
<?// Make a variable "$num" with a value "1".
$num=1;// Do while loop for out put records.
while($row=mysql_fetch_assoc($result)){// Plus 1 at $num.
$num++;// Use modulus by 2 in $num value and set the value of "$bg" if result equal 0 or not.
if(($num%2)!=0){
$bg="#FFCC00";
}else{
$bg="#CCCCCC";
}
?>
$num=1;// Do while loop for out put records.
while($row=mysql_fetch_assoc($result)){// Plus 1 at $num.
$num++;// Use modulus by 2 in $num value and set the value of "$bg" if result equal 0 or not.
if(($num%2)!=0){
$bg="#FFCC00";
}else{
$bg="#CCCCCC";
}
?>
<tr bgcolor="<? echo $bg; ?>">
<td><? echo $row['id']; ?></td>
<td><? echo $row['name']; ?></td>
</tr>
<?
// End while loop.
}
// Close database connection.
mysql_close();
?>
// End while loop.
}
// Close database connection.
mysql_close();
?>
</table>
</body>
</html>
No comments:
Post a Comment