I ran this
$query ="Select answer from answers where studentID ='A123456789'";
$result = mysql_query($query,$connection);
$resultArray = str_split($result,1);
$count = count($resultArray);
Where's the fetch?
|$result = mysql_query("SELECT answer FROM answers WHERE studentID = 'A123456789';");
$count = 0;
while ($row = mysql_fetch_assoc($result)) {
$count++;
}
|Of course you should count in the query if the result itself is not used:
|$result = mysql_query("SELECT COUNT(answer) AS nr_of_results FROM answers WHERE studentID = 'A123456789';");
$row = mysql_fetch_assoc($result);
$count = $row['||nr_of_results||'];||
|
Evert