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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to