----- Original Message -----
From: Evert Lammerts <evert.lammerts@xxxxxxxxx>
Date: Wednesday, March 26, 2008 4:04 pm
Subject: Re: 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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
