954,587 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Help with spacing of dynamically generated tables

This is a CSS/HTML issue, not php. Your php is suspect:

Line 15.

No need for all the tables? How about one table? Do you really need a table anyway? Why not use for name, or


for content?

Any reason why you'r using mysql_result? This tends to shift the internal pointer when called. Perhaps mysql_fetch_array() would be a better option with a while loop.

Also using * in your sql is a bit wasteful, you should name the fields you want.

diafol
Rhod Gilbert Fan (ardav)
Moderator
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
 

Your loop is messy.
This code shows simple looping for showing data in tabular form.

<?php
 $username="root";
 $password="";
 $database="";

 mysql_connect('localhost',$username,$password);
 @mysql_select_db($database) or die( "Unable to select database");
 $query="SELECT * FROM jokes";
 $result=mysql_query($query);

 echo '<table width="900%" border="0">';
 while($sar = mysql_fetch_assoc($result))
 {
 	echo '<tr>
    <td>'.$sar['name'].'</td>
    <td>'.$sar['content'].'</td>
  </tr>';
 }
 echo '</table>';
 mysql_close();
 ?>
vibhaJ
Posting Shark
931 posts since Apr 2010
Reputation Points: 161
Solved Threads: 183
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You