| ';
}
else {
//////////////////retrieving posts with specific criteria from the database
$query3 = "select * from _guestbook_posts where hotelname = '$hotelname' and location = '$location' and flag2 = '1' order by ID desc limit $offset,$limit";
$result3 = mysql_query($query3);
while ($row2=mysql_fetch_assoc($result3))
{
$ID = $row2['ID'];
$name = $row2['name'];
$title = $row2['title'];
$email = $row2['email'];
$email2 = $row2['email2'];
$post = $row2['post'];
$post2 = str_replace("\n", " ", $post); $date = $row2['date']; ?>
'; echo " "; //see if we're on the last page if (!((($offset)/$limit)+1==$pages)) { $last_record = $offset + $limit; //is last page Echo ' ';
echo " $last_record of $numrows Post(s).";
//echo ' ';
}
else
{
//is NOT last page - send this to browser
Echo '';
echo " $numrows of $numrows Post(s).";
//echo ' ';
}
echo "\n"; //prepare and display links to other results in browser if ($offset != 0) { $prevoffset=$offset-$limit; ?> >";?>
|
|||||||||
