mssql_fetch_array problem
| From: | Jennifer Arcino Demeterio | Date: | Tue, 19 Jun 2001 04:18:04 +0000 |
| Subject: | mssql_fetch_array problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9619@lists.php.net to get a copy of this message | ||
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!