|
Re:The problem with the link to the article 13 Years, 9 Months ago
|
Karma: 0
|
Thanks, now everything works.
How can I display only the desired section and the desired category items Joomla
When such a request shows all categories and all the sections:
SELECT title, transport, way, cost, duration, sectionid, catid, id, alias
FROM jos_content
Thanks in advance  |
|
|
|
Last Edit: 2011/02/11 12:09 By install.
|
|
|
Re:The problem with the link to the article 13 Years, 9 Months ago
|
Karma: 760
|
If you want to show articles from category with ID = 17, use the next query:
| Code: |
SELECT
title, transport, way, cost, duration, sectionid, catid, id, alias
FROM
jos_content
WHERE
catid = 17
|
If it is necessary to show articles from categories with ID = 21, 35, 47, use the following query:
| Code: |
SELECT
title, transport, way, cost, duration, sectionid, catid, id, alias
FROM
jos_content
WHERE
catid IN (21,35,47)
|
Use the next query if it is needed to show articles from section with ID = 15:
| Code: |
SELECT
title, transport, way, cost, duration, sectionid, catid, id, alias
FROM
jos_content
WHERE
sectionid = 15
|
Regards,
ARI Soft |
|
|
|
|
|
|
Re:The problem with the link to the article 13 Years, 9 Months ago
|
Karma: 0
|
|
Thanks for the quick response
good day
|
|
|
|
|
|
|
Re:The problem with the link to the article 13 Years, 9 Months ago
|
Karma: 0
|
|
Link to the material works only when the module is published on the front page "<a href="index.php?option=com_content&view=article&id={$columns:id}"> {$ value} </ a>"
If the module is not at home and on another page, it gives a 404 error
I need to change?
Thanks in advance
|
|
|
|
|
|
|
Re:The problem with the link to the article 13 Years, 9 Months ago
|
Karma: 760
|
We suppose you use core Joomla! SEF so this problem occurs. Try to use the following format string:
| Code: |
<a href="/index.php?option=com_content&view=article&id={$columns:id}">{$value}</a>
|
Regards,
ARI Soft |
|
|
|
|
|
|
Re:The problem with the link to the article 13 Years, 9 Months ago
|
Karma: 0
|
Thank you figured out actually in Joomla in the administrative section has been included if the SEO to turn it off but it has little sense of it all works and so
"<a href="index.php?option=com_content&view=article&id={$columns:id}"> {$ value.html} </ a>" |
|
|
|
|
|
|
