Hi Guys Im trying to make a php web page that will let me view my database i used this code below, i created the table but it doesn't show the values Please Help Me.......
<?php
$host = "localhost";
$username = "root";
$password = "";
$db_name="genetdb"; // Database name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// select record from mysql
$query="SELECT * FROM Products ";
$result=mysql_query($query);
?>
<table align="center" width="1080" border="10" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td colspan="5" bgcolor="#FFFFFF"><strong>Delete or Modify Data From Database</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Types</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Price</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Qty</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Size</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Origin</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Review</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Image</strong></td>
<td align="center" bgcolor="#FFFFFF"> </td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['Id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Types']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Price']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Qty']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Size']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Origin']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Review']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Image']; ?></td>
<td bgcolor="#FFFFFF"><a href="Delete_ac.php?id=<? echo $rows['id']; ?>">Delete</a></td>
<td bgcolor="#FFFFFF"><a href="Modify_ac.php?id=<? echo $rows['id']; ?>">Modify</a></td>
</tr>
<?php
// close while loop
}
?>
</table>
<?php
// close connection;
mysql_close();
return $result ;
?>