Previous post made to work with Image Manager LRG images where they exist. If image manager is not in use, this should do the trick:
Code:
<?php
/*Sequence for listing image paths for slideshow */
// do we want slideshow on this page?
if (isset($ezpage_id) and $ezpage_id == 'MY_EZ_PAGE_ID_#'){
//Hidden div to feed invisible images to jscript
echo "<div style=\"display:none\">";
// query database table for image paths
$this_sql_for_images = mysql_query("SELECT products_image FROM zen_products ORDER BY RAND()");
// loop through image paths and create array
while ($row = mysql_fetch_array($this_sql_for_images, MYSQL_NUM)) {
//assign string to variable
$the_url = $row[0];
if (file_exists("images/".$the_url)) {
//list images with "style = display:none" so they are not visible on page
} // End DB file exists Condition
//End hidden div tag
echo "</div>";
//display image - which will need to be uploaded - to click to begin slideshow
echo "<a href= \"images/clickhere.jpg\" rel=\"renmanimage\"><img src=\"images/clickhere.jpg\"></a><br/>";
} // End EZ Page ID Condition
?>
Bookmarks