I need help understanding the page 95 query.

Adonis · February 15th, 2010, 05:49 PM

On page 95 of the book there is some bolded code there that modifies the getSubCategories function in the MCats model. could someone please help me understand what exactly it's doing. The book gives no explanation of this code.

PHP Code:


			
foreach ($Q->result_array() as $row){
               $sql = "select thumbnail as src 
                       from products 
                       where category_id=".id_clean($row['id'])."
                       and status='active'
                       order by rand() limit 1";
               $Q2 = $this->db->query($sql);
 
           
               if($Q2->num_rows() > 0){
                $thumb = $Q2->row_array();
                   $THUMB = $thumb['src'];
               }else{
                   $THUMB = '';
               }
               $Q2->free_result();
               $data[] = array(
                   'id' => $row['id'], 
                   'name' => $row['name'], 
                   'shortdesc' => $row['shortdesc'],
                   'thumbnail' => $THUMB
               );
           }

Linc0ln · January 12th, 2011, 10:27 AM

It selects a thumnail picture for your subcategory from one of the appropriate products picture. So you don't have an exact picture for all the subcategories, but the code randomly gets one for it.

Example: you have a computer webshop and you have subcategory "Webcams". If you click on Webcams subcat, it search through all webcam products and choose one's picture (for example a M* VX3000's) and puts for the subcategory, so you see visually too, that below this subcat are webcams..
Clear enough?