How to use variable outside while loop in php -

<ul class="resp-tabs-list">     <?php     $get_products="select * `categories` order 'id' limit 0,4 ";     $run_products=mysqli_query($con, $get_products);     while($row_products=mysqli_fetch_array($run_products)){          //get data  database         $category_id=$row_products['cat_id'];         $product_title=$row_products['cat_title'];         ?>         <li> <?php echo $product_title;?></li>         <?php     }     ?> </ul>  //outside variable call $category_id   <?php    $get_top_pro="select * `products` product_cat= '$category_id'  limit 0,8"; $run_top_pro=mysqli_query($con, $get_top_pro);                                   while($row_top_products=mysqli_fetch_array($run_top_pro)){                                       $get_top_pro_id=$row_top_products['product_id'];                                         $get_top_pro_title=$row_top_products['product_title'];                                       $get_top_pro_image=$row_top_products['product_image']; 

i want pass $category_id variable fetching 8 products particular category.

you need save ids in array later use specific id category.

<?php $get_products="select * `categories` order 'id' limit 0,4 "; $run_products=mysqli_query($con, $get_products); $category_id = array(); //array save ids while($row_products=mysqli_fetch_array($run_products)){      //get data  database     $category_id[] = $row_products['cat_id']; //each id saved category_id array     $product_title=$row_products['cat_title'];     ?>     <li> <?php echo $product_title;?></li>     <?php } ?> 

or can use array_push() in inserting value array.

<?php $get_products="select * `categories` order 'id' limit 0,4 "; $run_products=mysqli_query($con, $get_products); $category_id = array(); //array save ids while($row_products=mysqli_fetch_array($run_products)){      //get data  database     array.push($category_id, $row_products['cat_id']); //each id saved category_id array     $product_title=$row_products['cat_title'];     ?>     <li> <?php echo $product_title;?></li>     <?php } ?> 

then, use specific id categories:

<?php     foreach ($category_id $category) {          $get_top_pro="select * `products` product_cat= '$category' limit 0,8";          $run_top_pro=mysqli_query($con, $get_top_pro);                                             while($row_top_products=mysqli_fetch_array($run_top_pro)){                                                  $get_top_pro_id=$row_top_products['product_id'];                                                    $get_top_pro_title=$row_top_products['product_title'];                                                  $get_top_pro_image=$row_top_products['product_image'];          }   }