troubleshooting Question

send variable with session php

Avatar of teera
teera asked on
PHP
3 Comments1 Solution217 ViewsLast Modified:
<?php $_SESSION['varname']  =  $row_ReComset['idPcSet']; ?> it send value of the last one of the row but i want to send $row_ReComset['idPcSet'] that should be the line that user click how can i do that
<?php require_once('../Connections/host88.php'); 
session_start();
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $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;
}
}
 
mysql_select_db($database_host88, $host88);
$query_ReComset = "SELECT * FROM CompSetHead";
$ReComset = mysql_query($query_ReComset, $host88) or die(mysql_error());
$row_ReComset = mysql_fetch_assoc($ReComset);
$totalRows_ReComset = mysql_num_rows($ReComset);
?><!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=utf-8" />
<title>Untitled Document</title>
</head>
 
<body>
<table width="200" border="1">
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><a href="comset2.php"><?php echo $row_ReComset['idPcSet']; ?></a></td>
      <td><?php echo $row_ReComset['PcSetCode']; ?></td>
      <td><?php echo $row_ReComset['PCSetname']; ?></td>
      <td><?php echo $row_ReComset['PcSetCustomer']; ?></td>
      <td><?php echo $row_ReComset['PcSetMfgDate']; ?></td>
      <td><?php echo $row_ReComset['PCSetAppointDate']; ?></td>
      <td><?php echo $row_ReComset['PCSetStaffName']; ?></td>
      <td><?php echo $row_ReComset['PCSETAgeePrice']; ?></td>
      <td><?php echo $row_ReComset['Remark']; ?></td>
      <td><?php echo $row_ReComset['TimesUp']; ?></td>
      <?php $_SESSION['varname']  =  $row_ReComset['idPcSet']; ?>
      
 
    </tr>
    <?php } while ($row_ReComset = mysql_fetch_assoc($ReComset)); ?>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($ReComset);
?>
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros