# How to make "SORT" function for guestbook?

**URL:** <https://forum.kirupa.com/t/how-to-make-sort-function-for-guestbook/44840>\
**Category:** flash\
**Created:** [March 8, 2004, 12:40pm UTC](https://forum.kirupa.com/t/how-to-make-sort-function-for-guestbook/44840 "2004-03-08T12:40:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Azazel](https://avatars.discourse-cdn.com/v4/letter/a/838e76/32.png) [@Azazel](https://forum.kirupa.com/u/Azazel)\
**Post date:** [March 8, 2004, 12:40pm UTC](https://forum.kirupa.com/t/how-to-make-sort-function-for-guestbook/44840/1 "2004-03-08T12:40:14Z")

</div>

What do i have to add to make the guestbook load the entries from bottom to top?? Now it’s top to bottom

**Frame 1:**  
[AS]  
// Create random number  
randNum = Math.random() \* 1000000;  
// System code  
System.useCodepage=true;  
// Create our LoadVars Object  
myData = new LoadVars();  
// Call to scripts for data  
myData.load(“historia.txt?” + randNum, myData, “POST”);  
// When all of our data loads …  
myData.onLoad = function () {   
gotoAndPlay(“view”);  
}  
// Stop movie  
stop();  
[/AS]

**Frame 11**  
[AS]  
// Clear imput boxes  
namn = “”;  
mail = “”;  
hemsida = “”;  
meddelande = “”;  
// Populate text field  
if (myData.result == “okay”) {  
historia\_txt.htmlText = myData.entries;  
} else {  
historia\_txt.htmlText = myData.errorMsg;  
}  
// Set tab order  
namn\_txt.tabIndex = 1;  
mail\_txt.tabIndex = 2;  
hemsida\_txt.tabIndex = 3;  
meddelande\_txt.tabIndex = 4;  
// create error messages  
error = “Ooops… nu värkar det som att du glömde nått här!”;  
// form check  
function formcheck() {  
if ((namn == null) || (namn == “”)) {  
namn = error;  
action = “”;  
}  
if ((meddelande == null) || (meddelande == “”)) {  
meddelande = error;  
action = “”;  
}  
if ((namn != “”) && (namn != error) && (meddelande != “”) && (meddelande != error)) {  
namn = namn\_txt.text;  
mail = mail\_txt.text;  
hemsida = hemsida\_txt.text;  
meddelande = meddelande\_txt.text;  
gotoAndPlay(“sending”);  
}  
}  
// Stop the movie  
stop();  
[/AS]

**Frame 21**  
[AS]  
// Create random number  
randNum = Math.random() \* 1000000;  
// Create our LoadVars Object  
myData = new LoadVars();  
// Call to scripts for data  
myData.load(“inlägg.php?” + randNum + “&namn=” + namn + “&mail=” + mail + “&hemsida=” + hemsida + “&meddelande=” + meddelande, myData, “POST”);  
// When all of our data loads …  
myData.onLoad = function () {  
if (myData.result == “okay”) {  
gotoAndPlay(“loading”);  
} else {  
gotoAndPlay(“view”);  
}   
}  
// Stop movie  
stop();  
[/AS]

**Frame 31**  
[AS]  
// Create random number  
randNum = Math.random() \* 1000000;  
// Create our LoadVars Object  
myData = new LoadVars();  
// Call to scripts for data  
myData.load(“historia.txt?” + randNum, myData, “POST”);  
// When all of our data loads …  
myData.onLoad = function () {   
gotoAndPlay(“view”);  
}  
// Stop movie  
stop();  
[/AS]

**PHP script**

```php

<?

if (!isset($namn) || !isset($meddelande) || empty($namn) || empty($meddelande)) {
print "&result=Fail";
print "&errorMsg=" . urlencode("Du måste skriva ditt namn och ett meddelande.");
exit;
}

$mail = strtolower($mail);

addentry($namn, $mail, $hemsida, $meddelande);

function addentry($namn, $mail, $hemsida, $meddelande) {

$posted = strftime("%d-%m-%y %R");

$meddelande = stripslashes($meddelande);

$file = fopen('historia.txt', 'a+');

if (!$file) {
print "&result=Fail";
print "&errorMsg=" . urlencode("Ett oväntat fel har inträffat. Försök igen om ett tag.");
exit;
}
 
fputs($file, "<font color=\"#673434\">Namn:</font> $namn
<font color=\"#673434\">Mail:</font><font color=\"#333333\"><A href=\"mailto:$mail\"> $mail</A></font><br>
<font color=\"#673434\">Hemsida:</font><font color=\"#333333\"><A href=\"http://$hemsida\"target=\"_blank\"> $hemsida</A></font><br>
<font color=\"#673434\">Den</font> $posted
<font color=\"#333333\">Skrev:</font> $meddelande

");
fclose($file);

//Send admin an email when new entry occurs
mailAdmin($name, $email, $website, $message);
}

function mailAdmin($namn, $mail, $hemsida, $meddelande) {
	$mailTo = "";
	$mailFrom = "Hemsidan";
	$mailSubject = "Gästboken";
	$mailBody = "Någon har gjort ett inlägg i gästboken:

	Namn: $namn
	Mail: $mail
	Hemsida: $hemsida
	Besökaren skrev:
	------------------------------
	$meddelande 
	------------------------------
//	You can view the message at:
//	http://www.yoursite.com";
//	mail($mailTo, $mailSubject, $mailBody, $mailFrom);
//	mail($mail, "Your Subject", "Thank you message", "From:");
}

print "&result=okay";
exit;

?>

```

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 11, 2004, 4:13pm UTC](https://forum.kirupa.com/t/how-to-make-sort-function-for-guestbook/44840/2 "2004-03-11T16:13:25Z")

</div>

Add a delimiter at the end of each entry:

```php
// we will use ":e:" as the delimiter
fputs($file, "New entry

:e:");

```

And the [font=courier new]if[/font] statement on frame 11 should read as follows:

```auto
if (myData.result == "okay") {
entries_str = myData.entries;
entries_array = entries_str.split(":e:");
entries_array.reverse();
entries_str = entries_array.join("");
historia_txt.htmlText = entries_str;
} else {
historia_txt.htmlText = myData.errorMsg;
}

```

…That would do, I think. 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 13, 2004, 1:29am UTC](https://forum.kirupa.com/t/how-to-make-sort-function-for-guestbook/44840/3 "2004-03-13T01:29:24Z")

</div>

No problem, Azazel. 😉