Page won't finish loading...why?

Anon

I have a simple page set up as follows:
- include file containing global vars
- query to a MySQL db
- output from the query into table rows
All working fine...
EXCEPT that the browser never "finishes" loading the page.

Everything has been output, quite quickly in fact...
but the browser won't stop processing... until you hit the "Stop" button.

I'm rather new to PHP/MySQL...
Any thoughts are appreciated. Thanks.

Anon

Lets see some source most likely its a while or loop that doenst have an end. Upload your source so we can see.

Anon

Hi Mike,

here's the code:

include("var_include.php");

$db = mysql_connect("$gbl_db_hst", "$gbl_db_usr");

if (! mysql_select_db("$gbl_db_nam") )
{
echo "<p>Unable to locate the database at this time.</p>";
exit;
}

$result = mysql_query("select uname, pword, moddate from logins",$db);

print "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">";
print "<tr><td><strong>uname</strong></td><td><strong>pword</strong></td><td><strong>created</strong></td></tr>";

while ($r = mysql_fetch_array($result)) {
extract($r);
print "<tr valign=\"top\"><td>$uname</td><td>$pword</td><td>$moddate</td></tr>";

}
print "</table>";

mysql_close($db);

====================

Anon

Anyone have any ideas?

(see previous messages for details)

trooper

Instea d of using extract try assigning the values to variables.

while ($r = mysql_fetch_array($result))
{
$uname =$r["username"];
$pword = $r["password"];
$moddate = $r["moddate"];
print "<tr valign=\"top\"><td>$uname</td><td>$pword</td><td>$moddate</td></tr>";
}

OK so it may not be as sexy as using extract but at least you'll get a better understanding of what may be going wrong.

Oh and no i cannot see whats wrong with your code ;-)

Gary Mailer

zalath

I'm clutching at straws here, but could your browser possibly be waiting for a </html> ? you don't seem to output one...

Anon

Unfortunately,
I didn't forget the ending tag.

Thanks to yourself and Gary for trying to help though.

I'm just going to avoid using that "extract" configuration for now.

I have to move on... there's other ways to skin this cat.

Cheers!