Page 1 of 1

storing data during session in mysql

Posted: Mon Apr 13, 2009 5:32 pm
by gwolff2005
Hi guys,

I need your help. How do I store data during a usersession in his userrow in mysql. I have a survey over three pages. The data needs to be saved after the user presses "continue" to get to the next page. Each page has 10 questions and the values for each questions are between 0 and five. The questions are divided in three different categories. So the results needed to be saved according the categories. The results always needs to be added in the mysql cell. I am grateful for any (good) hints! Thanks!!

Re: storing data during session in mysql

Posted: Mon Apr 13, 2009 6:04 pm
by tech603
I would say you could go about that two different ways. You could have each page submit to the next page and do your checks/inserts on the next page of each. Or your could store the variable in your session. Here are some tutorials on how to do that.

http://www.w3schools.com/PHP/php_sessions.asp
http://www.tizag.com/phpT/phpsessions.php

and this one shows how to store session variables using mysql.

http://www.tek-tips.com/faqs.cfm?fid=2037

Hope that helps.

Re: storing data during session in mysql

Posted: Tue Apr 14, 2009 7:52 am
by gwolff2005
OK... I really hope you can help me.. Ok I have got the login page (1.code) from there the useres come on the intro page (2nd code) from there will be a link to the psychological test (to get the programming right I just wrote a table to make it work.
My database is guntmar, table is users. the rows are resultspo, resultsmo and passion. The test has three pages (the submit button leads always to the next page, and at the same time the values should be stored in the mysql in the row of the user who is doing the test, so he can see it at anytime when he logs in again). The result of checkbox po, po1, etc.. need to be added in row resultspo, the results, mo, mo1, etc.. need to be added to row resultsmo, the results p, p1, etc.. need to be saved in row passion.
How can I do that??

Code: Select all

<?php require_once('Connections/Login.php'); ?>
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
session_start();
}
 
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
$_SESSION['PrevUrl'] = $_GET['accesscheck'];
}
 
if (isset($_POST['username'])) {
$loginUsername=$_POST['username'];
$password=$_POST['password'];
$MM_fldUserAuthorization = "";
$MM_redirectLoginSuccess = "intro.php";
$MM_redirectLoginFailed = "login.php";
$MM_redirecttoReferrer = false;
mysql_select_db($database_Login, $Login);
 
$LoginRS__query=sprintf("SELECT firstname, name, results, username, password FROM users WHERE username='%s' AND password='%s'",
get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 
 
 
 
$LoginRS = mysql_query($LoginRS__query, $Login) or die(mysql_error());
$row = mysql_fetch_array($LoginRS);          // ADDED
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {
   $loginStrGroup = "";
   //declare two session variables and assign them
   $_SESSION['MM_Username'] = $loginUsername;
   $_SESSION['MM_password'] = $row['password'];
   $_SESSION['MM_UserGroup'] = $loginStrGroup;   
   $_SESSION['MM_name'] = $row['name'];   // CHANGED 
   $_SESSION['MM_results'] = $row['results'];
   $_SESSION['MM_firstname'] = $row['firstname'];
 
 
if (isset($_SESSION['PrevUrl']) && false) {
$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];    
 }
header("Location: " . $MM_redirectLoginSuccess );
}
else {
header("Location: ". $MM_redirectLoginFailed );
}
}
if(isset($_POST['remember'])){
      setcookie("cookname", $_SESSION['MM_username'], time()+60*60*24*100, "/");
      setcookie("cookpass", $_SESSION['MM_password'], time()+60*60*24*100, "/");
   }
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style3 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 11px;
    font-weight: bold;
    color: #000033;
}
#Layer1 {
    position:absolute;
    left:71px;
    top:83px;
    width:473px;
    height:119px;
    z-index:1;
}
#Layer2 {
    position:absolute;
    left:71px;
    top:212px;
    width:354px;
    height:17px;
    z-index:2;
}
.style5 {
    font-size: 11px;
    color: #000033;
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-style: italic;
}
#Layer3 {
    position:absolute;
    left:110px;
    top:23px;
    width:245px;
    height:19px;
    z-index:3;
}
#Layer4 {
    position:absolute;
    left:71px;
    top:17px;
    width:235px;
    height:19px;
    z-index:3;
}
#Layer5 {
    position:absolute;
    left:360px;
    top:14px;
    width:401px;
    height:333px;
    z-index:4;
}
-->
</style>
</head>
<body>
<div id="Layer1">
  <form action="<?php echo $loginFormAction; ?>" method="POST" name="form1" target="_top" id="form1">
    <table width="400" border="0" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF">
      <tr>
        <td width="100" class="style3">Username:</td>
        <td><div align="left">
            <input name="username" type="text" class="style3" id="username" />
        </div></td>
      </tr>
      <tr>
        <td width="100"><span class="style3">Password:</span></td>
        <td><div align="left">
            <input name="password" type="password" class="style3" id="password" />
        </div></td>
      </tr>
      <tr>
        <td class="style3">Remember me: </td>
        <td><input name="remember" type="checkbox" id="remember" value="checkbox" /></td>
      </tr>
      <tr>
        <td width="100">&nbsp;</td>
        <td><div align="left">
            <input name="Submit" type="submit" class="style3" value="Submit" />
        </div></td>
      </tr>
    </table>
  </form>
</div>
<div class="style5" id="Layer2">If you don't have a login, please register <a href="register.php" target="_self">here</a>. </div>
<div id="Layer4"><a href="pics/buttonlogin.php"><img src="pics/buttonlogin.jpg" alt="" name="" width="257" height="19" border="0" /></a></div>
<div id="Layer5">
  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="400" height="325">
    <param name="flash_component" value="ImageViewer.swc" />
    <param name="movie" value="login.swf" />
    <param name="quality" value="high" />
    <param name="FlashVars" value="flashlet={imageLinkTarget:'_blank',captionFont:'Verdana',titleFont:'Verdana',showControls:true,frameShow:false,slideDelay:5,captionSize:10,captionColor:#333333,titleSize:10,transitionsType:'Random',titleColor:#333333,slideAutoPlay:false,imageURLs:['img1.jpg','img2.jpg','img3.jpg'],slideLoop:false,frameThickness:2,imageLinks:['http://macromedia.com/','http://macromedia.com/','http://macromedia.com/'],frameColor:#333333,bgColor:#FFFFFF,imageCaptions:[]}" />
    <embed src="login.swf" quality="high" flashvars="flashlet={imageLinkTarget:'_blank',captionFont:'Verdana',titleFont:'Verdana',showControls:true,frameShow:false,slideDelay:5,captionSize:10,captionColor:#333333,titleSize:10,transitionsType:'Random',titleColor:#333333,slideAutoPlay:false,imageURLs:['img1.jpg','img2.jpg','img3.jpg'],slideLoop:false,frameThickness:2,imageLinks:['http://macromedia.com/','http://macromedia.com/','http://macromedia.com/'],frameColor:#333333,bgColor:#FFFFFF,imageCaptions:[]}" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="400" height="325"> </embed>
  </object>
</div>
<div align="center"></div>
</body>
</html>

Code: Select all

<?php
//initialize the session
if (!isset($_SESSION)) {
  session_start();
}
 
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
  //to fully log out a visitor we need to clear the session varialbles
  $_SESSION['MM_Username'] = NULL;
  $_SESSION['MM_UserGroup'] = NULL;
  $_SESSION['PrevUrl'] = NULL;
  unset($_SESSION['MM_Username']);
  unset($_SESSION['MM_UserGroup']);
  unset($_SESSION['PrevUrl']);
    
  $logoutGoTo = "http://www.guntmarwolff.com";
  if ($logoutGoTo) {
    header("Location: $logoutGoTo");
    exit;
  }
}
?>
<?php require_once('Connections/Login.php'); ?><?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
 
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
// For security, start by assuming the visitor is NOT authorized. 
$isValid = False; 
 
// When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
// Therefore, we know that a user is NOT logged in if that Session variable is blank. 
if (!empty($UserName)) { 
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
// Parse the strings into arrays. 
$arrUsers = Explode(",", $strUsers); 
$arrGroups = Explode(",", $strGroups); 
if (in_array($UserName, $arrUsers)) { 
$isValid = true; 
} 
// Or, you may restrict access to only certain users based on their username. 
if (in_array($UserGroup, $arrGroups)) { 
$isValid = true; 
} 
if (($strUsers == "") && true) { 
$isValid = true; 
} 
} 
return $isValid; 
}
 
$MM_restrictGoTo = "index.html";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo); 
exit;
}
 
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Intro</title>
<style type="text/css">
<!--
.style3 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 11px;
    color: #000033;
}
.style8 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #000033; font-weight: bold; }
.style11 {color: #000033}
-->
</style>
</head>
<body>
<p>&nbsp;</p>
<table width="917" border="0">
  <tr>
    <td height="32" colspan="2" class="style8">&nbsp;</td>
    <td class="style8">&nbsp;</td>
    <td class="style8">&nbsp;</td>
    <td class="style3">&nbsp;</td>
    <td class="style3">&nbsp;</td>
    <td class="style3"><div align="right"><span class="style8"><a href="<?php echo $logoutAction ?>"><img src="pics/logout.jpg" width="86" height="24" border="0" longdesc="http://www.guntmarwolff.com" /></a></span></div></td>
  </tr>
  <tr>
    <td height="32" colspan="2" class="style8"><span class="style8">
 <script type="text/javascript">
    /*<![CDATA[*/
        function clock()
        {
            //////////////////////////////////////////////////////
            //Coded by the notorious jackpf
            /////////////////////////////////////////////////////
            
            //generate time
            var time = new Date();
            var hours = time.getHours();
            var minutes = time.getMinutes();
            var seconds = time.getSeconds();
            
            //add preceding 0s, if required
            var hours = (hours < 10 ? '0' : '')+hours;
            var minutes = (minutes < 10 ? '0' : '')+minutes;
            var seconds = (seconds < 10 ? '0' : '')+seconds;
            
            //generate formated time
            var time = hours+':'+minutes+':'+seconds;
            
            //get where abouts in the day it is
            if(hours >= 0 && hours < 12)
            {
                var greeting = 'Good Morning';
            }
            if(hours >= 12 && hours < 18)
            {
                var greeting = 'Good Afternoon';
            }
            if(hours >= 18 && hours < 00)
            {
                var greeting = 'Good Evening';
            }
            
            //display time
            document.getElementById('clock').innerHTML = time+'<br />'+greeting;
        }
        //init clock
        window.onload = function()
        {
            clock();
            setInterval('clock()', 1000);
        }
    /*]]>*/
</script>
<span id="clock"></span><?php echo " " .  $_SESSION['MM_firstname']; ?></span></td>
    <td width="71" class="style8">&nbsp;</td>
    <td width="107" class="style8">&nbsp;</td>
    <td class="style3">&nbsp;</td>
    <td width="164" class="style3"><div align="left"><span class="style3"><?php echo "You are logged in as<br>"?><em><strong><?php echo $_SESSION['MM_Username']; ?></strong></em></span></div></td>
    <td width="163" class="style3"><span class="style11">
      <?php 
//This file shows you how to include the file in your php document.
 
 
include("online.php"); 
?>
    </span></td>
  </tr>
  <tr>
    <td colspan="2" class="style3"></td>
    <td colspan="2">&nbsp;</td>
    <td width="125">&nbsp;</td>
    <td valign="top">&nbsp;</td>
    <td class="style3">&nbsp;</td>
  </tr>
  <tr>
    <td width="95">&nbsp;</td>
    <td width="162">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2" rowspan="15">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;<a href="<?php echo $logoutAction ?>"></a></p>
</body>
</html>

Code: Select all

<?php require_once('Connections/Login.php'); ?>
<?php
mysql_select_db($database_Login, $Login);
$query_Recordset1 = "SELECT users.resultspo, users.resultsmo, users.resultspassion, users.results FROM users";
$Recordset1 = mysql_query($query_Recordset1, $Login) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
session_start();
$_SESSION['MM_passion'] = $po; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script type="text/JavaScript">
<!--
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>
 
<body>
<form id="form1" name="form1" method="post" action="">
  <table width="667" border="1">
    <tr>
      <td>question one </td>
      <td width="210">passionorientation</td>
      <td width="346"><p>
        <label>
          <input type="radio" name="po" value="0" />
          0</label>
        <label>
        <input type="radio" name="po" value="1" />
1</label>
        <label>
        <input type="radio" name="po" value="2" />
2</label>
        <label>
        <input type="radio" name="po" value="3" />
3</label>
        <label>
        <input type="radio" name="po" value="4" />
4</label>
        <label>
        <input type="radio" name="po" value="5" />
5</label>
<br />
        <br />
      </p></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>passion</td>
      <td><p>
        <label>
          <input type="radio" name="p" value="0" />
          0</label>
        <label>
        <input type="radio" name="p" value="1" />
1</label>
        <label>
        <input type="radio" name="p" value="2" />
2</label>
        <label>
        <input type="radio" name="p" value="3" />
3</label>
        <label>
        <input type="radio" name="p" value="4" />
4</label>
        <label>
        <input type="radio" name="p" value="5" />
5</label>
<br />
      </p></td>
    </tr>
    <tr>
      <td height="34">&nbsp;</td>
      <td>motivation</td>
      <td></label>
        <input type="radio" name="m" value="0" />
0
</label>
<label>
<input type="radio" name="m" value="1" />
1</label>
<label>
<input type="radio" name="m" value="2" />
2</label>
<label>
<input type="radio" name="m" value="3" />
3</label>
<label>
<input type="radio" name="m" value="4" />
4</label>
<label>
<input type="radio" name="m" value="5" />
5</label></td>
    </tr>
    <tr>
      <td height="34">&nbsp;</td>
      <td>passionorientation</td>
      <td></label>
        <input type="radio" name="po1" value="0" />
0
</label>
<label>
<input type="radio" name="po1" value="1" />
1</label>
<label>
<input type="radio" name="po1" value="2" />
2</label>
<label>
<input type="radio" name="po1" value="3" />
3</label>
<label>
<input type="radio" name="po1" value="4" />
4</label>
<label>
<input type="radio" name="po1" value="5" />
5</label></td>
    </tr>
    <tr>
      <td height="34">&nbsp;</td>
      <td>passion</td>
      <td></label>
        <input type="radio" name="p1" value="0" />
0
</label>
<label>
<input type="radio" name="p1" value="1" />
1</label>
<label>
<input type="radio" name="p1" value="2" />
2</label>
<label>
<input type="radio" name="p1" value="3" />
3</label>
<label>
<input type="radio" name="p1" value="4" />
4</label>
<label>
<input type="radio" name="p1" value="5" />
5</label></td>
    </tr>
    <tr>
      <td height="34">&nbsp;</td>
      <td>motivation</td>
      <td></label>
        <input type="radio" name="m1" value="0" />
0
</label>
<label>
<input type="radio" name="m1" value="1" />
1</label>
<label>
<input type="radio" name="m1" value="2" />
2</label>
<label>
<input type="radio" name="m1" value="3" />
3</label>
<label>
<input type="radio" name="m1" value="4" />
4</label>
<label>
<input type="radio" name="m" value="5" />
5</label></td>
    </tr>
    <tr>
      <td width="89" height="34">&nbsp;</td>
      <td colspan="2"><p align="center">
        <input name="Submit" type="submit" onclick="MM_goToURL('parent','testtestpage2.php');return document.MM_returnValue" value="Submit" />
      </p>        </td>
    </tr>
  </table>
</form>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>