= 57) ) {
$sql.= " ORDER BY photo_id";
} else {
$sql.=" ORDER BY p.filename, p.photo_id";
}
$res = mysql_query($sql,$my_conn);
$num_rows = mysql_num_rows($res);
while ($thumbs = mysql_fetch_object($res)) {
$thumbscount++;
//some filenames in the database include a leading "/". remove it.
if (substr($thumbs->filename, 0, 1) == "/") {
$thumbs->filename = substr($thumbs->filename, 1, (strlen($thumbs->filename)-1));
}
$output.='
filename.'" alt="'.str_replace('"','"', str_replace("'","'", $thumbs->description)).'" title="'.str_replace('"','"', str_replace("'","'", $thumbs->description)).'">';
}
echo $output;
?>
