loop logical problem

[robert_gsfame]

i have two tables assume question and answer

 

question table consists of Question_Date, Question_id and Question_title

answer table consists of Answer_Date, Question_id, Answer_id and Answer_title

 

let say i have 1000 records and i wish to display only the last 100 records combining both question and answer.

 

How can i do this with loop..any suggestion would be appreciate

 

thx

[AbraCadaver]

Do it with the query not a loop:

 

SELECT * FROM question, answer WHERE question.Question_id = answer.Question_id ORDER BY Answer_Date DESC LIMIT 100

 

Or ORDER BY Question_Date, not sure what you want.

[robert_gsfame]

what if i want display all records from both table which Question_id is equal to 7

how can i do that with your query as i cant find anywhere to put the condition there  :confused:

[trq]

SELECT * FROM question, answer WHERE question.Question_id = answer.Question_id AND question.Question_id = 7 ORDER BY Answer_Date DESC LIMIT 100