Re: [PHP-DB] numeric string to single digit array
[email protected] (Evert Lammerts)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
> 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