"Geoff Berrow" <bl@ckdog.co.uk > wrote in message news:6i******** *************** *********@4ax.c om...
I noticed that Message-ID: <4W************ *******@news.xt ra.co.nz> from
WindAndWaves contained the following:
Would your code still work if I used something else rather then a cookie?
Care to tell us what or is it a secret? We could guess all day.
here is the code I use... I did not write it, but it seems to work.... Note that each page passes on the session ID to the next....
<?php
// Establish a session
session_start() ;
include_once("c onnectDB.php");
// Initialize variables
$errormessage = "";
$sqlStart = "SELECT a.id, a.FN, a.name, a.description, a.photolink, a.regionId FROM friars a, regions b";
$sqlWhere = " WHERE (a.regionId = b.id) AND ";
$sqlEnd = " GROUP BY a.regionId, a.name ";
$humanSQL = "<UL>";
$maxrows = 50;
$snum = 1;
$sql = "";
$name = "";
$basketcount = 0;
// If no sortorder is set, initialize it to 1
if(!$sortorder) {
$_SESSION["sortorder"] = 1;
}
// ADD TO TRIP
if($add){
// Add accomodation to the session with an incremented sortorder
$_SESSION["sortorder"] = $sortorder + 1;
$id = $add;
// Select DB data for accommodation to ADD and Append to Session
$sqladd = "SELECT * FROM friars WHERE id = $id";
$resultAdd = mysql_query($sq ladd);
$myrowAdd = mysql_fetch_arr ay($resultAdd);
// Get the Region Name
$regionId = $myrowAdd["regionId"];
$sqladd = "SELECT description FROM regions WHERE id = '$regionId'";
$resultAdd2 = mysql_query($sq ladd);
$myrowAdd2 = mysql_fetch_arr ay($resultAdd2) ;
//get name
$name = $myrowAdd["name"];
// Add name and id to the session
$_SESSION["cart"][$sortorder]["id"] = $id;
$_SESSION["cart"][$sortorder]["name"] = $name;
$_SESSION["cart"][$sortorder]["regionId"] = $myrowAdd["regionId"];
$_SESSION["cart"][$sortorder]["regiondesc r"] = $myrowAdd2["descriptio n"];
$_SESSION["cart"][$sortorder]["descriptio n"] = $myrowAdd["descriptio n"];
$_SESSION["cart"][$sortorder]["photolink"] = $myrowAdd["photolink"];
$_SESSION["cart"][$sortorder]["FN"] = $myrowAdd["FN"];
// GET THE SQL back
$sql = $_SESSION["sqlr"][$snum]["sqler"];
// sql = stripslashes($H TTP_POST_VARS[sqlS]);
$result = mysql_query($sq l);
$numrows = mysql_num_rows( $result);
//$locationer = 'results.php?PH PSESSID='. session_id().'' ;
//header("Locatio n: $locationer");
}
elseif ($HTTP_POST_VAR S[regSubmit] || $HTTP_POST_VARS[advSubmit]){
// Select properties from regions for normal and advanced search...
include_once("c onnectDB.php");
$sql = $sqlStart;
$sql .= $sqlWhere;
if(count($searc h) < 1){
............... ............... .........etc
}
if($HTTP_POST_V ARS[advSubmit]) { // ADVANCED SEARCH
............... ............... .........etc
}
<html.......... .......><A HREF="...?add=[propertycode]&.....>.... ............... ..../html>
