----- Original Message -----
From: Evert Lammerts <[EMAIL PROTECTED]>
Date: Wednesday, March 26, 2008 5:22 pm
Subject: Re: [PHP-DB] numeric string to single digit array

> > Tried that as well and got the same result. 
> > I tried "Select count(answer) as total from answers where 
> studentID='A123456789'";> from the CLI and got total = 2 as a 
> result.  
> >   
> So, we got rid of the Invalid Resource error and we know that the 
> student id you use occurs in both rows in your table and that your 
> query 
> works fine.
> Did you get rid of the semicolon @ line 15 "while($row = 
> mysql_fetch_assoc($result));", as Jason suggested? Also, an:
> error_reporting(E_ALL);
> at the top of your code might help in backtracing.

The semi-colon is gone, although I didn't even notice it! I am using two 
different queries, one for count and the other to access the data itself.  
After running mysql_fetch_assoc, is foreach ok for accessing array members, or 
is there a more subtle approach?

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to