Recently Uploaded

[Gashu]

I have a suggestion/request :D

It would be great if there were, on the homepage, a "recently uploaded pets" or "newest pets", like at the bottom of this site: http://www.icepets.com/homepage.php. Also, this would work well if there were items. Just something interesting to add to the front page :D

[mapleblade]

you can do this with a simple mysql query, but i cant make it atm because i gotta go to school ;l

[Gashu]

Aww wow really? I'm not too good with coding haha xD I've started using MyAdopts for a bit because it's a bit simpler haha, would the code be the same for that site?

[mapleblade]

try something like this:

PHP Code:

$query = "SELECT * FROM {$prefix}adoptables ORDER BY id DESC LIMIT 5";
            $result = runquery($query);
            $row = mysql_fetch_array($result);

$image = getcurrentimage($row['id']);

article_content .= '<img src="{$image}" /><br /><b>{$row['type']}</b>'; 


[Gashu]

Oh awesome, thanks so much! I'll try that soon then, MyAdopts seems to be down right now though :O I'll message back once I've tried it :D

[SilverDragonTears]

I could be wrong, but I don't think this will work on a MyAdopts site.

[Gashu]

Okay, I figured out how to make the themes work on Mysidia so I'm going to use this instead (and Myadopts still isn't up lol). Where exactly do I need to put this code? :P

[SilverDragonTears]

You want it to show on the index page right?

[Gashu]

Yup :D At the bottom of the index page :)

[SilverDragonTears]

What is your address?