Windows speed issue
| From: | Andrew Staples | Date: | Thu, 13 May 2004 18:25:51 +0000 |
| Subject: | Windows speed issue | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23719@lists.php.net to get a copy of this message | ||
I'm fairly new to php, hoping someone can help. I have a webpage that
displays records from a table. The problem is that viewing the page on via
any browser other than a browser directly on the server gives me a timeout
error. When run on the server, it's extremely fast. What am I doing wrong?
(I tried indexing the city fields). This is on a win2003 server.
The code is below.
<?
// open database connection
db_connect();
// generate and execute query
$query = "SELECT * FROM milage ORDER BY city";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print title with links to edit and delete scripts
while($row = mysql_fetch_object($result))
{
?>
<tr><td>
<font size="2"><b><? echo $row->city;
?></b></font></td>
<td>
<font size="2"><b><? echo $row->miles;
?></b></font></td>
<td><font size="2"><a href="edit.php?id=<? echo $row->cityid;
?>">Edit</a></td>
<td><a href="delete.php?id=<? echo $row->cityid;
?>">Delete</a></font></td>
</tr>
<?
}
}
// if no records present
// display message
else
{
?>
<font size="-1">No Locations Listed</font><p>
<?
}
// close connection
?>