I still get the same response. "Gurhan Ozen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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:[EMAIL PROTECTED]] > Sent: Monday, May 13, 2002 5:16 PM > 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