Thanks for all your answers, but, they still seem not to work. In my query,
the value of countryname is retrieved as expected but the value of countryid
is not. There seems to be no value retrieved for countryid. I am using
PHP4 on IIS4 on an NT machine with SQL Server 7 as the database.
Thanks for all your answers, but, they still seem not to work. In my query,
the value of countryname is retrieved as expected but the value of countryid
is not. There seems to be no value retrieved for countryid. I am using
PHP4 on IIS4 on an NT machine with SQL Server 7 as the database.
Ok lets start from the beginning, apologies if this these have been
mentioned previousely I haven't seent the rest of the thread:
* Make sure 'countryid' is spelled the same in your script as it is in
your DB table (I've done this and spent hours banging my head against
a brick wall)
*
Jennifer,
Try this code..I am using the same stuff as you with the exception of mysql instead of
sql..but it may still work:
?
$country_sql = select countryname co_name_val, countryid co_id_val from
TBL_COUNTRY;
if ($country_query = mssql_query($country_sql)) {
while ($myrow =
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
Demeterio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 6:18 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mssql_fetch_array problem
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
Not being able to see your code and not knowing exactly what problem you are
having I can only throw a few guesses here. If you could elaborate more on
what you are expecting and what you are getting that would be a big help.
snip
$country_sql = select countryname, countryid from TBL_COUNTRY;
try:
if ($country == intval($myrow[countryid]))
mssql_fetch_array is found to have some weird behavior.
On Tue, 19 Jun 2001, Jennifer Arcino Demeterio wrote:
hello all,
hope someone could help me
it seems that the mssql_fetch_array did not work as
Hello!!!
Try using the second argument of mysql _fetch_array
MYSQL_NUM
This will insure that an integer is used..
If not let me knowI'll do testing...
Dan Brunner
On Monday, June 18, 2001, at 11:18 PM, Jennifer Arcino Demeterio wrote:
hello all,
hope someone could