=2013;$i--) { $yearscounter++; $galscount = 0; $thumbs=""; $sql_select = "SELECT g.gallery_id, g.name, g.g_date, g.description, g.has_children, g.map_center_lat, 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"; $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_orderby; //echo ""; $res = mysql_query($sql,$my_conn); $num_rows = mysql_num_rows($res); ?>
< class="homepage">>
'; } else { $thumbs.='