Hoi,

heb zojuist de guestbook werkend gekregen JIPPY!!!! Nu wil ik dat de laatst ingevoerde gegevens eerst te zien zijn. Dit is het script:

Er moet een kleine verandering ergens komen, weet iemand het?
Danke u voor het lezen van mijn probleem!
Pierre
-----------------------


<?
require("config.php");
$totalentries=mysql_query("SELECT * FROM guestbook");
if(!$start) {
$start=1;
}
$begin=$start-1;
$sql=mysql_query("SELECT * FROM guestbook ORDER BY id ASC LIMIT $begin,1")
or die("&dataloaded=0&error=Can't fetch guestbook results! Check the database");

if(mysql_num_rows($sql)=="1")
{
$row=mysql_fetch_array($sql);

$exp=explode(" ",$row[date]);
$date=explode("-",$exp[0]);
$date="$date[2]-$date[1]-$date[0]";
$time="$exp[1]";
$name="$row[name]";
$email="$row[email]";
$website="$row[website]";
$comment="$row[comment]";
$totalentries=mysql_num_rows($totalentries);
echo"&dataloaded=1&start=$start&date=$date&time=$time&name=$name&email=$email&website=$website&comment=$comment&totalentries=$totalentries";
}
else {
echo"&start=0";
echo"&date=Nothing entered";
echo"&time=Nothing entered";
echo"&name=Nothing entered";
echo"&email=Nothing entered";
echo"&website=Nothing entered";
echo"&comment=Nothing entered";
echo"&totalentries=0";
echo"&dataloaded=1";
}
?>

-----------------------

$sql=mysql_query("SELECT * FROM guestbook ORDER BY id ASC LIMIT $begin,1")
veranderen in
$sql=mysql_query("SELECT * FROM guestbook ORDER BY id DESC LIMIT $begin,1")

Reageren