mysql_num_rows() didn't return 0 rows in Netscape where is IE return correct no. rows

bhasheth

Following is the code :

$result = mysql_query($modStmt, $link);

print($result);
// I guess, above code is being understood by NN and did print something like : Resource id #2

$num_row = mysql_num_rows($result);
print($num_row);

// I guess, above code is not understood by NN and did print 0 rows, where as IE printed 9 rows .

for ($i=0; $i < $num_row ; $i++){
$row = mysql_fetch_array($result);
printf("<tr>");
print("<td width=17%> $row[mod_id] </td>");
}

Could any one advice me please? Thanks.

mattuu

The sql statements you put in php are not interpreted by browsers. They are interpreted by the web server, and it sends the same data to any browser regardless of the browser type. If you had NN and IE get different results, something ELSE changed.

However, I notice in your code you have opening <TR> tags, but no closing </TR> tags. That's bad. Some NN versions, for example, will not display a page at ALL if there is an unmatched <TABLE> tag.

Anyhow, if you got different results from the

print($num_row);

line, then something else changed, but it wasn't a browser thing.

bhasheth

Actually, it is prining the table for me : for example header, footer of the table. But, not printing anything when it comes to print the data retrieved from the DB. It is because, $num_row has got the value 0, when run from NN. Well, the same code is priting data ( total of 9 rows) as well when run over the IE.

So, I keep wondering that why the server is returing 0 rows to NN where is correct number of rows to IE.

MrAlaska

You problem has to be related to HTML. If MySQL is returning 0 rows, then there must be something different in the form submitted to make the query. Have your code echo back the form inputs when the page first loads and look for anything peculiar. There might be something on your form page netscape doesn't understand so is putting something funky into the submission.

Also, echo back the SQL statement and look for anything funky.