Hi there, I'm trying out something like as follows
$query_Recordset1 = sprintf("SELECT mark WHERE class=A AS mark1, mark WHERE class=B AS mark2, mark WHERE class=C AS mark3
FROM biology WHERE
year = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $arundel) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
Is there not a simpler way of achieving this?
the first step to simplicity is...
... to pull out the mysql query, discard all the php code, and test your query directly in the mysql engine
please show us what that does first, before we simplify it further