Advanced Search

Return to Snippet

Revision: 30579
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