----- 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
