[hashom]

I'm trying to loop through a database and output data into table but not working any advise

<?php 
$sql = "SELECT * FROM info where ip='$ip2' LIMIT 5";
$result = $conn->query($sql); 
 while($row = $result->fetch_assoc()) {
  
?>	
  <table id="keywords" cellspacing="0" cellpadding="0">
    <thead>
      <tr>
        <th><span>URL</span></th>
        <th><span>Created Date</span></th>
        <th><span>Short </span></th>
        
      </tr>
    </thead>

<tbody>
		
     <tr> 
	  
        <td class="lalign"><?php echo $row["url"];?></td>
        <td><?php echo $row["short"];?></td>
		<td><?php echo $row["date"];?></td>
        <td>1</td>
		
    </tr>

</tbody><?php }?>
</table> 

[modi123_1]

Are you sure you are even getting rows back?

[CTphpnwb]

Deprecated MySQL functions are simpler to use (not counting all the sanitizing you need to add) than PDO or MySQLi prepared statements, but far less secure. That's why they've been deprecated. If you're just learning PHP you should start with
http://www.dreaminco...duction-to-pdo/
or
http://php.net/manua...-statements.php
When dealing with old code that uses deprecated MySQL functions you should replace them if possible. If it's not possible, your experience with PDO or MySQLi will benefit you when dealing with MySQL functions.

[andrewsw]

(Why are you attempting to repeat the whole table per row? But, even then, you are omitting the closing table tag each time, until the last table. Presumably, you should only be repeating the rows.)