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

----- Original Message -----
From: Evert Lammerts <[email protected]>
Date: Wednesday, March 26, 2008 4:04 pm
Subject: 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.
> 

OK. Tried that and count comes back as 1.