san_cash Posted December 11, 2009 Share Posted December 11, 2009 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"; }?> Quote Link to comment Share on other sites More sharing options...
vinpkl Posted December 11, 2009 Share Posted December 11, 2009 if you want to shift to new page after 20 results then you need to add paging script. try php section vineet Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.