Categories > TinyButStrong general >

Help in querying data

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: C.h
Date: 2010-03-22
Time: 11:00

Help in querying data

Hi, everybody

I have two data table:

question_db
-------------------
ID
content

answer_db
-------------------
ID
question_id
content

how do i list the specific questions and the answers of question at the same time and then show in a table?
By: C.h
Date: 2010-03-22
Time: 11:07

Re: Help in querying data

Forgot to tell that every quest has 4 answers, how do i use tbs to list one question with 4 answer within a row in a table?
By: TomH
Date: 2010-03-22
Time: 13:47

Re: Help in querying data

While that's mostly a db query issue... you'll find a good working example of how to write the TBS part in the "Examples" are of the TBS website. Examine the source code for the "Sub-blocks" example, specifically the "Subblock with dynamic query:" section.

Start here... http://www.tinybutstrong.com/examples.php

HTH,
By: C.h
Date: 2010-03-23
Time: 03:54

Re: Help in querying data

Thanks for replying,
I'm using tbssql, and how to use it like the "sub-block" sample?

thanks a lot.