Re: mssql_fetch_array problem

Hello!!! Try using the second argument of mysql _fetch_array MYSQL_NUM This will insure that an integer is used.. If not let me know....I'll do testing... Dan Brunner On Monday, June 18, 2001, at 11:18 PM, Jennifer Arcino Demeterio wrote:

hello all, hope someone could help me .... it seems that the mssql_fetch_array did not work as it should when the data type to be fetch is an integer ... is there any work around for this? Below is my script ... $country_sql = "select countryname, countryid from TBL_COUNTRY";

    if ($country_query = mssql_query($country_sql)) {
       while ($myrow = mssql_fetch_array($country_query))
          if ($country == $myrow["countryid"]) {
               print "<option value=" . $myrow["countryid"] . " selected>" .

$countryid . "</option>";

         } else {
               print "<option value=" . $myrow["countryid"] . ">" .

$countryid . "</option>";

         }
      }
    }

Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net