Re: [PHP-DB] numeric string to single digit array

> PHP is telling me that the resource I am using for mysql_fetch_assoc is invalid:
>
> $query ="Select answer from answers where studentID ='A123456789'";
> $result = mysql_query($query,$connection);
> $count=0;
> while($row = mysql_fetch_assoc($result));
> {
> $count++;
> }
> echo $count;
>   

Are you sure your database connection has been made?

$connection = mysql_connect('localhost', 'mysql_user', 'mysql_password') 
or die(mysql_error());
etc..

If the connection is made alright, try:

$query ="Select answer from answers where studentID ='A123456789'";
$result = mysql_query($query,$connection) or die(mysql_error());
$count=0;
while($row = mysql_fetch_assoc($result));
{
$count++;
}
echo $count;