Strange behavior in IE/SQL/PHP

bwcc · Jun 23, 2008

I am having an issue recently with IE (v7.0.5730.11) displaying more than 500 records from an SQL query. The browser seems to constantly execute - displaying and rehiding records (and the vertical scrollbar grows and shrinks). I have let the page go for about 5 minutes and it will continue this behavior until a user clicks on the webpage a second time.

I've tried connecting to multiple databases, different webservers, different computers.

Here's the code (stripped down version)

<?
$server="someserver";
$username="someuser";
$password="somepwd";
$sqlconnect=mssql_connect($server, $username, $password);
$sqldb=mssql_select_db("sometable",$sqlconnect);
?>
<html>
<head>
<title>Parking Control : Reports</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="lpac.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?
$rep=mssql_query("SELECT TOP 1500 account FROM entries");
?>
<div>
<span class="title" style="width:70px;"><a href="reports_print.php?o=1&<?=''.$v.''; ?>" title="Sort by Ticket #">Ticket#</a></span>
<span class="title" style="width:75px;"><a href="reports_print.php?o=2&<?=''.$v.''; ?>" title="Sort by Date">Date</a></span>
<span class="title" style="width:65px;"><a href="reports_print.php?o=3&<?=''.$v.''; ?>" title="Sort by Paid or Void">Paid/Void</a></span>
</div>
<div>
<?
for($i=0; $i<1500; $i++) {
$row = mssql_fetch_array($rep);
echo '
<div style="clear:both;">
<span class="data" style="width:70px;">'.$row['account'].'</span>
</div>';
} // end while
?>
</body>
</html>

I've also changed the for statement to a while statement. Same results.
Firefox seems to execute the code normally, as IE used to. Any ideas to this strange behavior?

MrChad · Jun 23, 2008

What happens when you remove the stylesheet?

EDIT: Alternatively, what happens when you use tables instead (this is, after all, tabular data)?

troytime · Jun 23, 2008

yeah IE sucks for big pages like that

Strange behavior in IE/SQL/PHP

bwcc

Member

MrChad

Lifer

troytime

Golden Member

TRENDING THREADS