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

> This is my code.  The only error is at line 15 as I stated above.
>
> 1 <?PHP
> 2 DEFINE ("host","localhost");
> 3 DEFINE ("user","root");
> 4 DEFINE ("password","password");
> 5 DEFINE ("database","questions");
> 6
> 7 $connection=mysql_connect(host,user,password) or die ('Could not connect' .mysql_error() );
> 8
> 9 $dbConnect=mysql_select_db('questions',$connection);
> 10 if (!$dbConnect) {die ('Could not connect to database' . mysql_error() );}
> 11
> 12 $query ="Select answer from answers where studentID ='A123456789'";
> 13 $result = mysql_query($query,$connection);
> 14 $count=0;
> 15 while($row = mysql_fetch_assoc($result));
> 16 {
> 17 $count++;
> 18 }
> 19 echo $count;
> 20 ?>
>
>   

Turn line 13 into
$result = mysql_query($query) or die(mysql_error());
, so leave out the connection parameter and append the die() function, 
and see what error that produces.