09-20-2007, 04:28 AM
It's possible to show only category in my news?, how?. For example, I would like to show one category (for example car) in my page car.php, category trucks in my page trucks.php, etc. Thank you.
09-20-2007, 04:28 AM
09-24-2007, 11:51 AM
This is possible. You would need to make copies of news.php, and call them news-cars.php, news-trucks.php, etc, and simply modify the queries. If you want me to be more specific, tell me what categories you have and what the category ID of each one is.
To tell what the ID for a category is, hover over the links next to it in the categories page and note the number at the end of the URL.
To tell what the ID for a category is, hover over the links next to it in the categories page and note the number at the end of the URL.
09-25-2007, 04:18 AM
Brian Wrote:
This is possible. You would need to make copies of news.php, and call them news-cars.php, news-trucks.php, etc, and simply modify the queries. If you want me to be more specific, tell me what categories you have and what the category ID of each one is.
To tell what the ID for a category is, hover over the links next to it in the categories page and note the number at the end of the URL.
To tell what the ID for a category is, hover over the links next to it in the categories page and note the number at the end of the URL.
In my news I have many categories. ¿It's possible to add any code in my news.php (for example, news.php?car, news.php?truck) to show that category that I want?. Thank you.
09-26-2007, 05:07 AM
It is possible, though the way page-including in general works, it will only be effective with PHP includes or iframes.
Anyway, in news.php, you could find:
Anyway, in news.php, you could find:
PHP Code:
isset($_GET['action']) ? $action = $_GET['action'] : $action = '';
And add below it:
PHP Code:
if (!isset($urlGetCat))
{
isset($_GET['category']) ? $urlGetCat = $_GET['category'] : $urlGetCat = '';
}
And then in news.php
Find:
PHP Code:
$getnews = $DB->query("SELECT * FROM `unp_news` ORDER BY `date` DESC LIMIT $newslimit");
Replace with:
PHP Code:
$getnews = $DB->query("SELECT * FROM `unp_news` WHERE `catid`='$urlGetCat' ORDER BY `date` DESC LIMIT $newslimit");
Now, if you are using frames, just include news.php?category=categorynumber, replacing categorynumber for each instance. If you are using PHP includes, link to your page as normal and add ?category=categorynumber to the link.
Let me know if anything is unclear.
09-27-2007, 08:30 PM
Brian Wrote:
It is possible, though the way page-including in general works, it will only be effective with PHP includes or iframes.
Anyway, in news.php, you could find:
Anyway, in news.php, you could find:
PHP Code:
isset($_GET['action']) ? $action = $_GET['action'] : $action = '';
And add below it:
PHP Code:
if (!isset($urlGetCat))
{
isset($_GET['category']) ? $urlGetCat = $_GET['category'] : $urlGetCat = '';
}
And then in news.php
Find:
PHP Code:
$getnews = $DB->query("SELECT * FROM `unp_news` ORDER BY `date` DESC LIMIT $newslimit");
Replace with:
PHP Code:
$getnews = $DB->query("SELECT * FROM `unp_news` WHERE `catid`='$urlGetCat'[/B] ORDER BY `date` DESC LIMIT $newslimit");
Now, if you are using frames, just include news.php?category=categorynumber, replacing categorynumber for each instance. If you are using PHP includes, link to your page as normal and add ?category=categorynumber to the link.
Let me know if anything is unclear.
I have this error (I have intalled News Illustrated)
Code:
Database error in Utopia News Pro:
Invalid SQL Query: SELECT * FROM `unp_news` WHERE `catid`=''[/B] ORDER BY `date` DESC LIMIT 10
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[/B] ORDER BY `date` DESC LIMIT 10' at line 1
MySQL Error Number: 1064
Date: September 27, 2007 12:27 PM
Script: /
09-28-2007, 12:58 PM
Recopy the last line of code I gave and try again. There was a typo in it.
09-28-2007, 05:45 PM
It doesn't work. Not show anything. Thank you.
09-29-2007, 12:57 AM
Can you give me a link to the page your news is being displayed on, and tell me the URL to NewsPro itself? I think all the code is in place to make this work now, and it's just a question of implementation.
12-17-2007, 04:35 AM
Brian, You are super. Thanks very much. I edited my script for the categories and it worked!!!
12-17-2007, 04:44 AM
That's great to hear. 