Problems showing form values on thanks page

[robert]

Hi,

I'm new to this forum but think I can help with a solution.

First of all create a Connections folder with following php file (dbf.php) in it

PHP Code:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_dbf = "localhost";
$database_dbf = "your_database_name";
$username_dbf = "the_database_user_name";
$password_dbf = "the_database_user_password";
$dbf = mysql_pconnect($hostname_dbf, $username_dbf, $password_dbf) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Let your 'thanks' page start with following PHP code
(replace 'dbf' on filename and code with any name of your choice)

PHP Code:

<?php require_once('Connections/dbf.php'); ?>
<?php 
session_start();

   mysql_select_db($database_dbf, $dbf);
    
   $query_rsAnyName = "SELECT * FROM ft_form_1 ORDER BY submission_id DESC";
                      
   $rsAnyName = mysql_query($query_rsAnyName, $dbf) or die(mysql_error());
   $row_rsAnyName = mysql_fetch_assoc($rsAnyName);
   $totalRows_rsAnyName = mysql_num_rows($rsAnyName);

   $cfieldname1  = $row_rsAnyName['col_1'];   
   $cfieldname2  = $row_rsAnyName['col_2']; 

?>

The $cfieldname variables are those you wish to show wherever on your thanks page. For example if you wish to show a submitted Name and E-mail address:

PHP Code:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="22%">Name</td>
                    <td width="78%"><?php print $cfieldname1; ?></td>
                  </tr>
                  <tr>
                    <td>E-mail</td>
                    <td><?php print $cfieldname2; ?></td>
                  </tr>

</table> 


Hope this helps. It works fine on my thanks pages.

Cheers,
Robert