[F8] guestbook + php + SQL store and get entries by unique id

tomera

Hi there I've got a guestbook setup to work with my video site. It loads as external swf into an empty mc and stores and loads entries by making calls to SQL table using php file. Everything works fine but I'd like to improve it so it works based on unique video clips IDs. I've got many videos on my site and I'd like to store entries based on unique video IDs then retrieve only the relevant entries when a unique video is called. I'm not a SQL/php expert but I understand that I'll need to create a special column in my SQL table to store unique video IDs and then change the php code so it stores and retrieves entries from the table based on the same unique IDs system.

Does anyone have any ideas or tips on how to do this?
cheers

here is my php code:

$action = $_GET['action'];

switch($action) {
case 'read' :
$sql = 'SELECT * FROM ' . $table . '';
$allComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
$numallComments = mysql_num_rows($allComments);
$sql .= ' ORDER BY time DESC LIMIT ' . $_GET['NumLow'] . ', ' . $numComments;
$fewComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
$numfewComments = mysql_num_rows($fewComments);
print '&totalEntries=' . $numallComments . '&';
print " &entries=";

if($numallComments == 0) {
print "No entries in the guestbook, as yet..";
} else {
while ($array = mysql_fetch_array($fewComments)) {
$name = mysql_result($fewComments, $i, 'name');
$email = mysql_result($fewComments, $i, 'email');
$comments = mysql_result($fewComments, $i, 'comments');
$time = mysql_result($fewComments, $i, 'time');
print 'Name: ' . $name . ' Comments: ' . $comments . ' Date: ' . $time . ' ';
$i++;
}
}

tomera

Ok some success here: I've added another column to my table and called it titleID, I've altered the code on my php and added:

case 'write' :
// Receive Variables From Flash
$titleID = ereg_replace("&", "%26", $POST['titleID']);
$name = ereg_replace("&", "%26", $POST['yourname']);
$email = ereg_replace("&", "%26", $POST['youremail']);
$comments = ereg_replace("&", "%26", $POST['yourcomments']);
$submit = $_POST['submit'];

   // Current system date in yyyy-mm-dd format
   $submitted_on = date ("Y-m-d H:i:s",time());

   // Check if its submitted from Flash
   if($submit == 'Yes'){
   // Insert the data into the mysql table
   $sql = 'INSERT INTO ' . $table .
            ' (`ID`,
                               'titleID'
           `name`,
           `email`,
           `comments`,
           `time`
          )
          VALUES
          (\'\','
                               . '\'' . $titleID . '\','
           . '\'' . $name . '\','
           . '\'' . $email . '\','
           . '\'' . $comments . '\','
           . '\'' . $submitted_on . '\'
           )';
   $insert = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());

then I added another textInput component for the titleID and called it videoID and recoded the AS so now I'm able to send the titleID number from flash to my table using php.
Now I'd like to fetch back into the read area of my guestbook only entries that have this unique titleID number.
How do I alter the read code in the php form to do this?

case 'read' :
// Fetch all comments from database table
$sql = 'SELECT * FROM ' . $table . '';
$allComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
$numallComments = mysql_num_rows($allComments);
// Fetch page-wise comments from database table
$sql .= ' ORDER BY time DESC LIMIT ' . $_GET['NumLow'] . ', ' . $numComments;
$fewComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
$numfewComments = mysql_num_rows($fewComments);
// Generate Output for Flash to Read
print '&totalEntries=' . $numallComments . '&';
print " &entries=";

any ideas?
cheers.

bradgrafelman

When posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.