/ Published in: PHP
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
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 return null; } for ($idx = 0; $idx < $rowCount; $idx++) { $assoc["$table.$field"] = $row[$idx]; } return $assoc; }
URL: http://www.thesecretary.org/