display mysql record in html format

[san_cash]

sir can anyone help me in putting the data in html format. the script looks like the following. i want the data to be inside the table and is 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"; }?>

[vinpkl]

if you want to shift to new page after 20 results then you need to add paging script.

 

try php section

 

vineet