\n\n"; for ($i=date("Y");$i>=2005;$i--) { $yearscounter++; $galscount = 0; $cycle_images=""; $cycle_text=""; $sql_select = "SELECT g.gallery_id, g.name, g.g_date, g.description, g.has_children, p.filename, c.camera_folder_name "; $sql_from = "FROM (gallery g LEFT JOIN photo p ON g.thumbnail_id = p.photo_id) "; $sql_join = "LEFT JOIN camera c ON p.camera_id = c.camera_id"; $sql_parent = " AND parent_id=0 "; $sql_orderby=" ORDER BY g.g_date DESC, g.gallery_rank"; //show private galleries only to logged in users if (session_is_registered(user_id)){ $sql_where = " WHERE g.active=1 AND g.g_date LIKE('".$i."%')"; } else { $sql_where = " WHERE g.active=1 AND g.public=1 AND g.g_date LIKE('".$i."%')"; } //put the SQL pieces together $sql=$sql_select.$sql_from.$sql_join.$sql_where/*.$sql_parent*/.$sql_orderby; echo ""; $res = $my_conn->query($sql); echo '
'; foreach ($res as $gals) { $galscount++; $parts = split("/", $gals["filename"]); $maxparts = count($parts); $cycle_images.=''; $cycle_text.='
'.$gals["name"].'

'.$gals["description"].'

'; } echo ' '.$cycle_images.'
'.$cycle_text.'
'; } echo '
'; ?>