Categories > TinyButStrong general >

How to show all rows from table

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Michael
Date: 2012-03-07
Time: 22:56

How to show all rows from table

Hi
Im a new user of TBS and so far i love it :)
I am trying to show all members from a database table, like i would do in php using a while.
<div>
while($row = mysql_fetch_array($result)){
    echo "<p>" .$row['name']. " - ". $row['age']."</p>";
}
</div>

How can i achieve this with tiny but strong ?
By: Skrol29
Date: 2012-03-07
Time: 23:21

Re: How to show all rows from table

Hi,

HTML:
<div>
  <p>[r.name;block=p] - [r.age]</p>
</div>

PHP:
$TBS->MergeBlock('r', $result);
or:
$TBS->MergeBlock('r', 'mysql', 'SELECT ... FROM ...');
By: Michael
Date: 2012-03-07
Time: 23:31

Re: How to show all rows from table

Thank you so much
It worked :)