Create online Contract - mysql query

Hey,

I'm still trying to make this works... some more research and I got this:

1) created a php form (my page 1) to post the data, in this form I created only an insert record server behavior

2) created a contract page (second page), where I set up a session variable as follow

<?php session_start(); session_register("sess_id"); $sess_id = $HTTP_POST_VARS['id']; ?>

where "id" is the autoincrement field filled in with my page 1 post.

Then I inserted a session variable, and named it "sess_id", the same as I named in the session_start, and draged it into my code.

<?php echo $_SESSION['sess_id']; ?>

Then I created a recordset, and in the filter I choose "id" = session variable "id" (also tried as session variable "sess_id", since I dont know if I was supposed to just leave the field or the session name), and in the bindings window I draged the fields into the respective cells.

But is still not working ! now I'm getting this messages...

Can anyone please help with this ? What am I doing wrong?

Follow the whole php code

<?php require_once('Connections/locaweb.php'); ?>
<?php session_start(); session_register("sess_id"); $sess_id = $HTTP_POST_VARS['id']; ?>
<?php echo $_SESSION['sess_id']; ?>

<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_Recordset1 = "-1";
if (isset($_SESSION['sess_id'])) {
  $colname_Recordset1 = $_SESSION['sess_id'];
}
mysql_select_db($database_locaweb, $locaweb);
$query_Recordset1 = sprintf("SELECT * FROM dados_contrato WHERE id = %s", GetSQLValueString($colname_Recordset1, "int"));
$Recordset1 = mysql_query($query_Recordset1, $locaweb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);


?>

Hi,

After some online research I've created a recordset and created a session variable filtering by id, after that I draged each mysql field into the php cell from the recordset panel.

But it is not working...

$colname_retrieve_data = "-1";
if (isset($_SESSION['LAST_INSERT_ID()'])) {
  $colname_retrieve_data = $_SESSION['LAST_INSERT_ID()'];
}
mysql_select_db($database_locaweb, $locaweb);
$query_retrieve_data = sprintf("SELECT * FROM dados_contrato WHERE id = %s", GetSQLValueString($colname_retrieve_data, "int"));
$retrieve_data = mysql_query($query_retrieve_data, $locaweb) or die(mysql_error());
$row_retrieve_data = mysql_fetch_assoc($retrieve_data);
$totalRows_retrieve_data = mysql_num_rows($retrieve_data);

What I'm I doing wrong? Just remembering I nee to retrieve the last data inserted by the loged in user.

Anyone can help ?