I have a web site game that I'm programming and right now I'm doing multiple MySQL grabs but I'm sure there must be a better way.
Code: Select all
$query_getpopulation = "SELECT COUNT(id) AS total FROM `c` WHERE v = $v AND age > 65;";
...
$senior = $row_getpopulation['total'];
$query_getpopulation = "SELECT COUNT(id) AS total FROM `c` WHERE v = $v AND age < 18;";
...
$child = $row_getpopulation['total'];
$query_getpopulation = "SELECT COUNT(id) AS total FROM `c` WHERE v = $v AND gender = 1;";
...
$male = $row_getpopulation['total'];