SanchezDell
New Member
Can I use a single SQL statement to return three separate results I can display through PHP? I'm looking to formulate three different "total" counts on a single table with three different conditions.Eg something like....\[code\]$resultGetTotals = SELECT COUNT(Total1) FROM table_xyz WHERE Status = X AS Total1SELECT COUNT(Total2) FROM table_xyz WHERE Status = X AND Person = Y AS Total2SELECT COUNT(Total3) FROM table_xyz WHERE Status = Y AND Person = X AS Total3while ($rGetTotals = mysql_fetch_array($resultGetTotals)){$Total1 = $rGetTotals["Total1"]$Total2 = $rGetTotals["Total2"]$Total2 = $rGetTotals["Total2"];}Total One is: <?php print $Total1; ?><br>Total Two is: <?php print $Total2; ?><br>Total Three is: <?php print $Total3; ?><br>\[/code\]Any help greatly appreciated 