Revision: 30579
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 17, 2010 21:41 by microbians
Initial Code
function projectFirstThumb($idslug){ global $clerk; // Only one row (because one id unique) $project = mysql_fetch_alias_array( $clerk->query_select( 'projects', '', 'WHERE projects.slug="'.$idslug.'"' ) ); // Not found try by ID not slug if ($project=="") { $project = mysql_fetch_alias_array( $clerk->query_select( 'projects', '', 'WHERE projects.id="'.$idslug.'"' ) ); } if ($project['projects.thumbnail'] != '') { return PROJECTS_URL.$project['projects.slug'].'/'.$project['projects.thumbnail']; } else { $filesGet = $clerk->query_select( 'project_files', '', 'WHERE type="image" AND project_id='.$project['projects.id'].' ORDER BY filegroup,pos ASC LIMIT 1'); while ( $file = mysql_fetch_alias_array($filesGet)) { return PROJECTS_URL.$project['projects.slug'].'/'.$file['project_files.thumbnail']; } } return ''; } function mysql_fetch_alias_array($result) { // Avoid the problem of duplicated field names in joint queries // From Post by Mehdi Haresi in PHP.net if (!($row = mysql_fetch_array($result))) { return null; } $assoc = Array(); $rowCount = mysql_num_fields($result); for ($idx = 0; $idx < $rowCount; $idx++) { $table = mysql_field_table($result, $idx); $field = mysql_field_name($result, $idx); $assoc["$table.$field"] = $row[$idx]; } return $assoc; }
Initial URL
http://www.thesecretary.org/
Initial Description
Initial Title
thesecretary.org / projectFirstThumb
Initial Tags
Initial Language
PHP