output a nice list of Q and A in the right order (was "MySQL newbie question")

[Ize]

Hi,

I'm working on a CMS for a FAQ-page.
Since there can be unlimited questions/answers added by the administrator, I guess I'll have to use some sort of join in order to link questions and answers together.

I now have two tables, questions and answers respectively, looking like this:

questions
---------
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
text TEXT

answers
-------
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
text TEXT

I'm afraid this isn't the right approach, but I'm really not very familiar with joins.
How can I output a nice list of Q and A in the right order?

[Ize]

By the way, phpinfo() says the following:
"Client API version 3.23.49"

[busy]

Will each question only have one answer, and each answer only have one question?

If this is true, why not just use one table?

[Ize]

Will each question only have one answer, and each answer only have one question?

If this is true, why not just use one table?

Yes, each question will have one answer and vice versa.
Hm, you're right...
Damn, where did my mind wander off to? The whole afternoon I've been Googling for JOIN references...

[guelphdad]

Please choose more appropriate thread titles when you post here in future. If everyone chose titles such as "MySQL newbie question" it would make the discussion board useless for everyone.

Also you should consider upgrading your version of mysql. Yours is seriously out of date. MySQL offers upgrades to their product about every month or so. Your version is more than 3 years old. You will be very limited in what you can do with that version of mysql.

as to joins etc. check the articles on this site under php/mysql I believe there are ones that explain joins.

[longneck]

By the way, phpinfo() says the following:
"Client API version 3.23.49"

that's not the mysql server version. that is the version of the client built in to php.

[busy]

If you want to make that current, you can download the correct one from here. Explanations are on the page as well.

http://dev.mysql.com/downloads/connector/php/