This file is only ever called by the Flash movie, so we don't really need to do a check for the existence of variables beforehand. They will already exist.
So here we go. Set your datasource.
The variable 'todo' is used in both calls and if it is set to 'sign'.
then let's sign the guestbook by inserting a new entry. All the information we need comes directly from the Flash movie.
INSERT INTO guestbooktbl(visitorFullname,comment, dateOfMessage,live,visitorEmail,homepageURL) VALUES( NULL, '#name#' NULL, #CreateODBCDateTime(Now())#, 1, '#comment#' NULL, '#email#' NULL) '#url#'
Now let's read all the entries in the database and store the results in order of the date they were entered. Most recent first.
SELECT * FROM guestbooktbl WHERE live=1 ORDER BY dateOfMessage DESC
That's the database done with. Now set up a couple of variables Flash needs.
|» Level Advanced|
Rating: 8 Votes: 161
|No information about the author has been provided|
|Download the files used in this tutorial.|
|Download (1159 kb)|
|More help? Search our boards for quick answers!|