sir can anyone please help me as i am a beginner in putting the data in html format. the script looks like the following. i want the data to be inside the table and it should go to the next page when data crosses 20.
<?php
include("connect.php");
$query="SELECT * FROM company ";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();
if ($num > 0 ) {
$i=0;
while ($i < $num) {
$name_ = mysql_result($result,$i,"name_");
$address = mysql_result($result,$i,"address");
$telephone = mysql_result($result,$i,"telephone");
$email = mysql_result($result,$i,"email");
$company = mysql_result($result,$i,"company");
$id = mysql_result($result,$i,"id");
echo "<b>ID :</b> $id<br>";
echo "<b>Name :</b> $name_<br>";
echo "<b>Address:</b> $address<br>";
echo "<b>Telephone:</b> $telephone<br>";
echo "<b>Email:</b> $email<br>";
echo "<b>Company:</b> $company<br>";
echo "<a href=\"update.php?id=$id\">Update</a> - <a href=\"delete.php?id=$id\">Delete</a>";
echo "<br><br>";
++$i; } } else { echo "The database is empty"; }
?>
thanks in advance
Santosh