$query2 = "SELECT * FROM table WHERE genre = 'action'";
$results = mysql_query($query);
$amount = "0";
while ($amountline = mysql_fetch_assoc($results2)) {
$amount++;
}
$dividedby4 = $amount / 4;
To start with '$amount' is equal to 34.
Therefore '$dividedby4' is equal to 8.5.
I wish to be able to round the 8.5 up or down.
Also whether or not you can actually figure out how much is after decimal e.g. 0.87
(if this made sense)
Anyone got any clues?