# Guestbook 89% done.. help me to finish it

**URL:** <https://forum.kirupa.com/t/guestbook-89-done-help-me-to-finish-it/180343>\
**Category:** Uncategorized\
**Created:** [February 27, 2006, 11:08pm UTC](https://forum.kirupa.com/t/guestbook-89-done-help-me-to-finish-it/180343 "2006-02-27T23:08:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Napoly](https://avatars.discourse-cdn.com/v4/letter/n/a9adbd/32.png) [@Napoly](https://forum.kirupa.com/u/Napoly)\
**Post date:** [February 27, 2006, 11:08pm UTC](https://forum.kirupa.com/t/guestbook-89-done-help-me-to-finish-it/180343/1 "2006-02-27T23:08:35Z")

</div>

Guestboook.zip contains:  
1.GuestBook.php //you need to initiate a mySQL Database Connection  
2.install\_guestbook.txt //SQL file  
3.Guestbooook.swf  
4.Guestbooook.fla

It’s all working for me really nicely… you can see it at [www.schranz-com.org](http://www.schranz-com.org) … but it has a little bugs… like for example after the Imput is sended the text boxes aren’t clear… or if it requireding valid name , e-mail adress the clear button just won’t clear. Also I would like to ask how to import special characters from MySQL to text… by special characters I mean for example “+” … also if any of you know any tutorial or something on how to insert smilies…

AS for clear button:  
on (release) {  
yourname.text = “”;  
youremail.text = “”;  
yourcomments.text = “”;  
}

AS for submit button:  
on(release) {  
yourname = yourname.text;  
youremail = youremail.text;  
yourcomments = yourcomments.text;

```
// Check variable data
if (yourname eq "") {
    gb_status.text = "Required: Name";
} else if (youremail eq "") {
    gb_status.text = "Required: Email Address";
} else if (!youremail.length || youremail.indexOf("@") == -1 || youremail.indexOf(".") == -1) {
    gb_status.text = "Required: Valid Email Address";
} else if (yourcomments eq "") {
    gb_status.text = "Required: Comments";
} else {
    gb_status.text = "Please wait...";
    newEntry = new LoadVars()
    newEntry.ref = this
    newEntry.submit = "Yes" 
    newEntry.yourname = yourname
    newEntry.youremail = youremail 
    newEntry.yourcomments = yourcomments 
    newEntry.sendAndLoad("GuestBook.php?action=write&r="+random(999), newEntry, "POST") 
    newEntry.onLoad = function(success){ 
        if(success){ 
            gb_status.text = this.gb_status;
            _parent.read.loadEntries("Default", 10);
            yourname.text = "";
            youremail.text = "";
            yourcomments.text = "";
        }
    } 
}

```

}

Moustly it’s gonna be a path problem… I have a hard time with that… thnx