1

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 <h3> for name, <p> or <div> 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.

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by vibhaJ
1

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();
 ?>
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.