| Latest photo albums |
| Author | Text |
Andrei Junior Member
Posts: 87

Gender:  Online: No
Country: Romania |
Date: 19/12/2008 16:17 Latest photo albums | #post16321 | Latest photo albums. Can be done? |
|
 |
| |
mem MemHT's Dad Admin & Developer

Posts: 7243

Gender:  Online: No
Languages: English, Italiano, Македонски, Српски |
Date: 19/12/2008 18:16 Re: Latest photo albums | #post16323 | Last images? Edited: 19/12/2008 18:16 |
|
 |
| |
Andrei Junior Member
Posts: 87

Gender:  Online: No
Country: Romania |
Date: 19/12/2008 18:17 Re: Latest photo albums | #post16324 | yes |
|
 |
| |
mem MemHT's Dad Admin & Developer

Posts: 7243

Gender:  Online: No
Languages: English, Italiano, Македонски, Српски |
Date: 19/12/2008 18:24 Re: Latest photo albums | #post16326 | Use the random gallery block and change the ORDER BY RAND() into ORDER BY id DESC |
|
 |
| |
Andrei Junior Member
Posts: 87

Gender:  Online: No
Country: Romania |
Date: 19/12/2008 19:18 Re: Latest photo albums | #post16331 | Line: 181
| code | if ($resultg = $dblink->get_list("SELECT * FROM memht_gallery_images AS i JOIN memht_gallery_categories AS c ON i.category=c.id WHERE i.enabled=1 ORDER BY id DESC LIMIT 5")) { |
| quote | Errno: 2 (MySQL Errno: 0)
File: /home/x/public_html/x/pages/test/index.php
Line: 181
Function: get_list
MySQL error:
Query: SELECT * FROM memht_gallery_images AS i JOIN memht_gallery_categories AS c ON i.category=c.id WHERE i.enabled=1 ORDER BY id DESC LIMIT 5
Note: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource |
|
|
 |
| |
mem MemHT's Dad Admin & Developer

Posts: 7243

Gender:  Online: No
Languages: English, Italiano, Македонски, Српски |
Date: 19/12/2008 19:25 Re: Latest photo albums | #post16334 | ORDER BY i.id DESC sorry |
|
 |
| |
Andrei Junior Member
Posts: 87

Gender:  Online: No
Country: Romania |
Date: 19/12/2008 21:04 Re: Latest photo albums | #post16339 | Thanks!
Now
What should I change?
|
|
 |
| |
mem MemHT's Dad Admin & Developer

Posts: 7243

Gender:  Online: No
Languages: English, Italiano, Македонски, Српски |
Date: 19/12/2008 22:38 Re: Latest photo albums | #post16341 | Just look at the file output. It's html, easy to change.. and use your fantasy + some html tutorial Edited: 19/12/2008 22:38 |
|
 |
| |
Andrei Junior Member
Posts: 87

Gender:  Online: No
Country: Romania |
Date: 13/03/2009 18:13 Re: Latest photo albums | #post18762 | last photos from a cateogrie. Can be done? |
|
 |
| |
mem MemHT's Dad Admin & Developer

Posts: 7243

Gender:  Online: No
Languages: English, Italiano, Македонски, Српски |
Date: 13/03/2009 21:25 Re: Latest photo albums | #post18769 | WHERE category=N ORDER BY ....
where N is the ID of the category |
|
 |
| |