Search the Community

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 ; ?>