RE: [PHP-DB] mssql_fetch_array not working?
| From: | Peter Lovatt | Date: | Mon, 13 May 2002 21:37:35 +0000 |
| Subject: | RE: [PHP-DB] mssql_fetch_array not working? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19164@lists.php.net to get a copy of this message | ||
hi
The code looks OK
Try something like
while ($row = mssql_fetch_array($rs));
{
echo "another row<br>";
echo $row["ItemClassKey"];
echo "<br>";
}
}
to see if it is looping thro the results, if so then the array
$row["ItemClassKey"] is empty - check the obvious - index case and that
there is data in the field in the record.
If it is not looping thro then could the if($rs) be moving the pointer to
the end of he result set, so there is nothing left to loop thro?
hth
Peter
-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
info@sunmaia.net
tel. 0121-242-1473
-----------------------------------------------
> -----Original Message-----
> From: Benjamin Walling [mailto:bwalling@edentaldirect.com]
> Sent: 13 May 2002 22:16
> To: php-db@lists.php.net
> Subject: [PHP-DB] mssql_fetch_array not working?
>
>
> I apologize if the answer to this is incredibly simple. I'm
> trying to learn
> PHP, and evaluate whether to change our site away from ASP.
>
> I have the following php code, and I can't get any results.
>
> I have add the line echo mssql_num_rows($rs); to see how many rows are
> returned, and I get 11 (there are 11 rows in this table).
>
> The page outputs only "11<br>Done". Why am I not getting any thing into
> $row? Why do I only get 1 <br> (I would expect 11)?
>
> --Begin Code
>
> $db = mssql_connect("domino","uid","pwd");
> if ($db)
> {
> $dbs = mssql_select_db("acuity_edd_app",$db)
> or die("Couldn't set DB");
> $sql = "SELECT * FROM timItemClass ORDER BY ItemClassID";
> $rs = mssql_query($sql);
> echo mssql_num_rows($rs);
> if ($rs)
> {
> while ($row = mssql_fetch_array($rs));
> {
> echo $row["ItemClassKey"];
> echo "<br>";
> }
> }else{
> echo "No results\n";
> }
> echo "Done\n";
> }else{
> echo "Unable to connect to database.\n";
> }
>
> --End Code
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>