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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
> [EMAIL PROTECTED]
> tel. 0121-242-1473
> -----------------------------------------------
>
> > -----Original Message-----
> > From: Benjamin Walling [mailto:[EMAIL PROTECTED]]
> > Sent: 13 May 2002 22:16
> > To: [EMAIL PROTECTED]
> > 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

Reply via email to