View Single Post
Old 04-09-2004, 05:27 PM   #2
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
First of all, welcome to the phpDig forum, Peter. We're glad to have you here.

This is untested, but please find the following code in search_function.php:
PHP Code:
$query "SELECT sites.site_url, sites.port, spider.path,spider.file,spider.first_words,
sites.site_id,spider.spider_id,spider.last_modified,spider.md5 "
."FROM ".PHPDIG_DB_PREFIX."spider AS 
spider, "
.PHPDIG_DB_PREFIX."sites AS sites "
."WHERE spider.spider_id=$spider_id AND sites.site_id = spider.site_id"
and change it like so:
PHP Code:
$query "SELECT sites.site_url, sites.port, spider.path,spider.file,spider.first_words,
sites.site_id,spider.spider_id,spider.last_modified,spider.md5 "
                      
."FROM ".PHPDIG_DB_PREFIX."spider AS spider, ".PHPDIG_DB_PREFIX."sites AS sites "
                      
."WHERE spider.spider_id=$spider_id AND sites.site_id = spider.site_id ORDER BY spider.last_modified"
Be sure to remove any word wrapping in the above code.

Let us know if this worked, too. Thanks!
vinyl-junkie is offline   Reply With Quote