How to get the IDs of content parts within an article?

Cassiel · Post by **Cassiel** » Thu 17. Nov 2005, 18:32

Okay here's a question for you guys:

I have an article with ID 1 let's say. And within this article I have three content parts for example: 2, 3 and 4. Now here's what I want: I want to know how I can query the article with ID 1 to get the content part number 3. Anyone knows how to do it?

The whole id, a_id, u_id fields within the MySQL table are really tricky if you don't know the meaning. Maybe someone can tell me if not able to answer my question above.

Thanks in advance!

Regards,
Cassiel

Post by **Oliver Georgi** » Thu 17. Nov 2005, 23:03

this is very simple - but don't forget sorting. Based on this you can make a decision.

I think I know what you have in mind by asking this question.

Oliver

Kosse · Post by **Kosse** » Fri 18. Nov 2005, 12:16

Oliver Georgi wrote:this is very simple - but don't forget sorting. Based on this you can make a decision.

I think I know what you have in mind by asking this question.

Oliver

duh

I'm lost here...
I get the question but the reply seems 'sherlock holmish'...

...
How simple is it? If u have some time to reply

thx

Cheers

Post by **Oliver Georgi** » Fri 18. Nov 2005, 13:50

check "content.article.inc.php". Sorry, I have no time to explain it here at the moment.

Oliver

Cassiel · Post by **Cassiel** » Fri 18. Nov 2005, 21:20

Well thanks..

Cassiel · Post by **Cassiel** » Tue 13. Dec 2005, 11:30

Sorry but I didn't get it.

Please Oliver, give me a hint. Thanks!

Edit: Okay, think I got it.

Example:

Code: Select all

SELECT *
FROM phpwcms_article as article
INNER JOIN phpwcms_articlecontent as acontent
WHERE article.article_id = acontent.acontent_aid
AND article.article_id = X

*Note: X = Your 'article_id' from table 'phpwcms_article' you want to fetch