Re: Trouble running a select query against a database, when I know the connection is working, and the data is there
| From: | Jacob Kruger | Date: | Wed, 14 Apr 2010 02:06:26 +0000 |
| Subject: | Re: Trouble running a select query against a database, when I know the connection is working, and the data is there | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-30033@lists.php.net to get a copy of this message | ||
Thanks.
Figured it out, and also know shouldn't just copy and paste too much code as such...<smile>
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message ----- From: "Toby Hart Dyke" <toby@hartdyke.com>
To: "Jacob Kruger" <jacobk@mailzone.co.za>
Cc: <php-windows@lists.php.net>
Sent: Tuesday, April 13, 2010 12:00 PM
Subject: Re: [PHP-WIN] Trouble running a select query against a database, when I know the connection is working, and the data is there
On 4/13/2010 9:36 AM, Jacob Kruger wrote:__________ Information from ESET NOD32 Antivirus, version of virus signature database 5026 (20100413) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com$qry = mysql_query($sql); $arr = mysql_fetch_array($qry); if ($arr.count > 0) { echo "<ul>"; while($row = mysql_fetch_array($arr))You retrieve a row, check if it has any elements, then attempt to retrieve the next row, using the array you just created as the argument. You should be using $qry as the argument, but you're skipping over the first row. Toby __________ Information from ESET NOD32 Antivirus, version of virus signature database 5026 (20100413) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com