RE: [PHP-DB] mssql_fetch_array not working?
| From: | Gurhan Ozen | Date: | Mon, 13 May 2002 21:41:05 +0000 |
| Subject: | RE: [PHP-DB] mssql_fetch_array not working? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19166@lists.php.net to get a copy of this message | ||
Are you sure???
Did you make sure that the ItemClassKey field is not empty?
Gurhan
-----Original Message-----
From: Benjamin Walling [mailto:bwalling@edentaldirect.com]
Sent: Monday, May 13, 2002 5:38 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] mssql_fetch_array not working?
I still get the same response.
"Gurhan Ozen" <c-gurhan.ozen@wcom.com> wrote in message
news:NEBBJFKICMBBMAOHJDFOCEDGDGAA.c-gurhan.ozen@wcom.com...
> Hi ...
> Get rid of the if($rs) block...
> Just do:
>
> while ($row = mssql_fetch_array($rs));
> {
> echo $row["ItemClassKey"];
> echo "<br>";
> }
>
> Gurhan
>
> -----Original Message-----
> From: Benjamin Walling [mailto:bwalling@edentaldirect.com]
> Sent: Monday, May 13, 2002 5:16 PM
> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php