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)) {

|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||'];||

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to