Re: mssql_fetch_array not working?
| From: | Benjamin Walling | Date: | Mon, 13 May 2002 21:42:22 +0000 |
| Subject: | Re: mssql_fetch_array not working? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19167@lists.php.net to get a copy of this message | ||
It's the ';' at the end of the while statement. It runs the loop with no
statements in it, then executes the code in brackets. I copied some bum
code from a tutorial...
"Peter Lovatt" <pjln1@sunmaia.net> wrote in message
news:NFBBKAGAILLHPFOOAKFIMEGMDIAA.pjln1@sunmaia.net...
> 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
> >
>