records 'sometimes' not displayed

Anon

Hello

I have a simple query set up which selects all records from a table based on a criteria. Strange thing is, with a handful of users, not all records are displayed 'sometimes'. They have to click on 'refresh' on their browsers and the rest of the records show up. Any ideas as to any work-arounds? Im using msql_fetch_array.

Cheerss

<?php include("dbconnect.php"); ?>
<?

$result = mysql_query("select * from post where course='computing' ORDER by title");
if ($result){
//echo ": ";
echo "<table width=90% align=center border=1><tr>
<td align=left bgcolor=#FFFFFF>Book Title</td>
<td align=left bgcolor=#FFFFFF>Author
</td>
<td align=left bgcolor=#FFFFFF>Author 2</td>
<td align=left bgcolor=#FFFFFF>Selling Price</td>
<td align=left bgcolor=#FFFFFF>Request!</td>

</tr>";
while ($row = mysql_fetch_array($result)) {
echo"
<tr>
<td>$row[title]</td>
<td>$row[author1]</td>
<td>$row[author2]</td>
<td>$row[our_price]</td>
<td><a href=\"request_book.php?book_id=$row[book_id]\">More Info</a></td>
<td>

</tr>";
} echo "</table>";
} else {
echo "No data.";
}
mysql_free_result($result);

mistcat

maybe send refresh headers? such as:

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// always modified
header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");