Random Photos

[lordphate]

Okay, so this is what i'm trying to do. I want to pull photo_small and art_id out of the database, but i want to pull them at random

 

here's what I have but it's still listing in same order:

 

[code=php:0]
function tattoo_slide(){



$sql_query="SELECT art_id, photo_small

			FROM tatoo_art WHERE approved='1' ORDER BY RAND() LIMIT 1";

$result = $GLOBALS["DB"]->result($sql_query);
    $tatslide = prepare_photos_array($result);

$tatslide["total"] = count($result);

    $tatslides = array();

$counter = 0;

foreach($result as $res){


$tatslide["links"]   = "http://tatfactory.com/index.php?page=art&section=view&art_id=".$res["art_id"];

	 $tatslide["images"]   = $res["photo_small"];

$conveyor .= 'leftrightslide['.$counter.']=\'<a href="'.$tatslide["links"].'"><img src="/photos/'.$tatslide["images"].'" border=0></a>\';';

$counter +=1;

}//foreach

$GLOBALS["smarty"]->assign("conveyor",$conveyor);

     }         //tattoo_slide

[/code]

[PC Nerd]

instead of specifying rand in the SQL, use shuffle on the array retreived.

 

 

gdlk