How to select all or get all the data in a table?

[eluser]mr_prasanna[/eluser]
Replace

Code:

<?php foreach ($results as $row) ?>
<h2>&lt;?php echo $row['id'] ?&gt;</h2>
<h3>&lt;?php echo $row['Name'] ?&gt;</h3>

with this

Code:

<?php foreach ($results as $row) ?>
<h2>&lt;?php echo $row['id'] ?&gt;</h2>
<h3>&lt;?php echo $row['Name'] ?&gt;</h3>
&lt;?php endforeach; ?&gt;

Basically, endforeach is missing.