Multiple mysql query

mysql, query,

[phpmysql]

I never had to do this before, so I'm wondering what is the best way. I have a couple mysql_query

$select = mysql_query("SELECT sku, qty FROM inventory");
$select2 = mysql_query("SELECT MAX(qty) AS sales FROM orders");
$select3 = mysql_query
$select4 = mysql_query

I am building a report table with the mysql_fetch_array

while($row = mysql_fetch_array($select))
{
echo "<tr>";
echo "<td>" .$row['sku']."</td>";
echo "<td>" .$row['qty']."</td>";
echo "<td>" space for $select2 result"</td>";
echo "<td>" space for $select3 result"</td>";
echo "<td>" space for $select4 result"</td>";
echo "</tr>";
}

I was wondering if you can put a couple of mysql queries together without using the mysql table join method?

Thanks

[jatar_k]

no you would need to join or union

but you can execute each query and add the results to the same array, or a bunch of different ones, and then output them all together

[nathanalog]

jatar_k,

How do you add results to the same array? I'm trying to do something similar:

 $query = 'SELECT * FROM skid_steer_loaders ORDER BY model DESC';
 $query .= 'SELECT * FROM track_steers';
 $result = mysql_query($query, $connection);
 if($result && mysql_num_rows($result) == 0)
 { echo "<p>No Listings</p>";}
else
{while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{echo '<p>' . $row['machine_name'] . '</p>';}
}

Obviously this doesn't work, but it's the idea that I'm trying to implement. Any suggestions?

[nathanalog]

I was looking for a specific answer here, which I didn't know lie in UNION. Here's an example of having several different queries held in 1 variable:

$query = 
'(SELECT id, machine_name, model, add_info, price FROM art_haul_trucks ORDER BY model) UNION ALL
(SELECT id, machine_name, model, add_info, price FROM compact_ex ORDER BY model) UNION ALL 
(SELECT id, machine_name, model, add_info, price FROM crawler_dozers ORDER BY model) UNION ALL
(SELECT id, machine_name, model, add_info, price FROM excavators ORDER BY model) UNION ALL 
(SELECT id, machine_name, model, add_info, price FROM full_ex ORDER BY model) UNION ALL
(SELECT id, machine_name, model, add_info, price FROM hyd_hammers ORDER BY model) UNION ALL 
(SELECT id, machine_name, model, add_info, price FROM loader_bh ORDER BY model) UNION ALL
(SELECT id, machine_name, model, add_info, price FROM mid_ex ORDER BY model) UNION ALL 
(SELECT id, machine_name, model, add_info, price FROM skid_steer_loaders ORDER BY model DESC) UNION ALL
(SELECT id, machine_name, model, add_info, price FROM track_steers ORDER BY model) UNION ALL
(SELECT id, machine_name, model, add_info, price FROM vib_rollers ORDER BY model) UNION ALL 
(SELECT id, machine_name, model, add_info, price FROM wheel_loaders ORDER BY model)
';

This may or may not be ideal. I realize now that I can avoid doing this by restructuring my database (in my particular instance).

[jatar_k]

>> I realize now that I can avoid doing this by restructuring my database

as is often the case when the above set of queries is a requirement

that is some nasty stuff