a simple code for using the latest images on an HTML page...

[alexpalermoo]

Hey!
I have been looking everywhere for a code like "http://www.breatheheavy.com"...they have the latest pictures from thier coppermine gallery automatically updated on their non-coppermine gallery page (the index page of the site)...and i need help trying to find the code! thanks!

[alexpalermoo]

nd im not using CMPFetch thingy...just a simple code...

[François Keller]

nd im not using CMPFetch thingy...just a simple code...

the you must code it yourself 

[Joachim Müller]

Doesn't get simpler than that.

[just_some_guy]

Code Select Expand


<?php

// MYSQL connect info here 
// Alter `cpg1411` to the table prefix you use
$sql = 'SELECT filename,filepath FROM `cpg1411_pictures` ORDER BY ctime DESC LIMIT 10;'; 
// Alter the number after LIMIT to define the number of pictures you want
$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {
echo '<img src="';  
echo $row['filepath'];
echo $row['filename'];
echo '"  />';
}

?>


That will start you off, you may need to alter the code etc. I know this is'nt support for coppermine, but i had a few free minutes.

[alexpalermoo]

what is the CMPFetch?
will it get what i want?

[alexpalermoo]

I DID IT!!!!! soo thanks for the people who helped!