Read the directions completely before beginning




                                                               
Read the directions completely before beginning.
This program instantly posts guestbook submissions and lists them from most
recent postings.  It also blocks two like submit names so each posting is
individualized. 

All things you need to be aware of are in red.

To set up your MySQL Database you will need to consult your hosting service.
They have different protocols for setting it up. Once you get it setup follow
the instructions below.

Guestbook -MySQL Table Instructions.

1. Once you open you Database, go down to "Create new
table on database..."
    
and type "blogbox" in the "name"
text box.

2. Then type "6" in the text box labeled "Fields"
and click on GO.

3. On the next page, Going across from the left type "id"
in the "Field" box.

4. Then in the "Type" select "INT"


5. In the box "Length/Values*", type "11"

6. Skip "Attributes" and in "Null"
box select "not null".  Then go to
"Extra" and select "auto_
increment". and indicate the Index Radio
button.

7 Go to the next line.

8. In the "Field" box type "address"

9. In the "Type" box select "VARCHAR".

10. In the box "Length/Values*", type "100".

11. Skip "Attributes" and in "Null"
box select "null".

12. Go to the next line.

13. In the "Field" box type "postdate"

14. In the "Type" box select "VARCHAR".

15. In the box "Length/Values*", type "100".

16. Skip "Attributes" and in "Null"
box select "null".

17. Go to the next line.

18. In the "Field" box type "name"

19. In the "Type" box select "VARCHAR".

20. In the box "Length/Values*", type "100".

21. Skip "Attributes" and in "Null"
box select "null".

22. Go to the next line.

23. In the "Field" box type "email"

24. In the "Type" box select "VARCHAR".

25. In the box "Length/Values*", type "150".

26. Skip "Attributes" and in "Null"
box select "null".

27. Go to the next line.

28. In the "Field" box type "comment"

29. In the "Type" box select "VARCHAR".

30. In the box "Length/Values*", type "250".

31. Skip "Attributes" and in "Null"
box select "null".

32. Click Save.



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

To set up your php script.  
Below is how the webpage connects to the MySQL database. Depending on the
hosting company this part of the script could be different. Email the tech
support of your hosting company and ask "What is the connection string protocol
for the MySQL database?" 

1. Right-click "config.php" and go to "open
with..." and then "notepad".

2. Change $hostname="yourdatabasehost";

3. Change $username="yourusername";

4. Change $password="yourpassword";

5. Change $dbname="yourdatabasename";



Another connection string we have come across is...

$dbh=mysql_connect ("localhost", "username", "<PASSWORD
HERE>") or die ('I cannot connect to the database because: ' .
mysql_error());
mysql_select_db ("database name");
 


If you have to do this one you will need to open all the scripts and change :the
two lines below to the one above.


mysql_connect($hostname,$username, $password) or die
("error");
mysql_select_db($dbname);

Upload everything to
your website.  In the same folder as your other HTML Documents.