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

[eluser]towki[/eluser]
[quote author="mr_prasanna" date="1342365113"]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.[/quote]

Thanks mr_passana for your reply. But I didnt get it to work when i tried your code.
It show me this error

Parse error: syntax error, unexpected T_ENDFOREACH in C:\xampp\htdocs\basicwebsite\application\views\view_data.php on line 6