How to generate output from MySQL when there are more than one queries?

Question

PHP

There are several tables in the database. At the moment, I take out one query from 2 tables and display it like this:

while($row = mysql_fetch_array($result))
{
  echo "ID: ".$row['id_product']." ";
  echo "Имя: ".$row['name']."<br>";
  echo "Цена закупочная: ".$row['wholesale_price']."<br>";
  echo "Цена продажи: ".$row['price']."<br>";
        $list = array ($name.$wholesale_price.';'.$price.';'.$profit);
  foreach ($list as $line) {
    fputcsv($fp, explode(';', $line));
  }
}

Well, then I also enter all the goodness received into a .csv file.
I would like to get several arrays for several requests from the database (one request - one array).
And then output all this happiness to the browser and to a .csv file

Answer 1

$queries = [
    'cars'=>'SELECT some FROM cars',
    'users'=>'SELECT some FROM users'
];

$results = [
    'cars'=>[],
    'users'=>[],
];

foreach($queries AS $name=>$query) {
    //тут выполнение запроса и далее как у Вас:
    while($row = mysql_fetch_array($result)) {
        $results[$name][] = $row;
    }
}

PS: and stop using MySQL API, use PDO

Answer 2

$list = array();
while($row = mysql_fetch_array($result))
{
  echo "ID: ".$row['id_product']." ";
  echo "Имя: ".$row['name']."<br>";
  echo "Цена закупочная: ".$row['wholesale_price']."<br>";
  echo "Цена продажи: ".$row['price']."<br>";
        $list[] = $name.$wholesale_price.';'.$price.';'.$profit;
}
while (another_query) {
        // ...
        $list[] = '...';
}
// ...
foreach ($list as $line) {
        fputcsv($fp, explode(';', $line));
}

Answer 3

Well, do 2 requests and for each save the result to your own array, what's wrong?