Ok, that's fine. I understand now... SO they are showing id's and redirects me to cart but nothing in the cart... Here are the 2 recordsets:
<?php
$maxRows_WADAcounsellors = 10;
$pageNum_WADAcounsellors = 0;
if (isset($_GET['pageNum_WADAcounsellors'])) {
$pageNum_WADAcounsellors = $_GET['pageNum_WADAcounsellors'];
}
$startRow_WADAcounsellors = $pageNum_WADAcounsellors * $maxRows_WADAcounsellors;
mysql_select_db($database_eating01, $eating01);
$query_WADAcounsellors = "SELECT counsellorID, first_name, bio, `fees_session`, type_of_therapy, `county_country`, town, postcode, professional_body FROM counsellors";
setQueryBuilderSource($query_WADAcounsellors,$WADbSearch1,false);
$query_limit_WADAcounsellors = sprintf("%s LIMIT %d, %d", $query_WADAcounsellors, $startRow_WADAcounsellors, $maxRows_WADAcounsellors);
$WADAcounsellors = mysql_query($query_limit_WADAcounsellors, $eating01) or die(mysql_error());
$row_WADAcounsellors = mysql_fetch_assoc($WADAcounsellors);
if (isset($_GET['totalRows_WADAcounsellors'])) {
$totalRows_WADAcounsellors = $_GET['totalRows_WADAcounsellors'];
} else {
$all_WADAcounsellors = mysql_query($query_WADAcounsellors);
$totalRows_WADAcounsellors = mysql_num_rows($all_WADAcounsellors);
}
$totalPages_WADAcounsellors = ceil($totalRows_WADAcounsellors/$maxRows_WADAcounsellors)-1;
$maxRows_counsellorsAddSelected = 10;
$pageNum_counsellorsAddSelected = 0;
if (isset($_GET['pageNum_counsellorsAddSelected'])) {
$pageNum_counsellorsAddSelected = $_GET['pageNum_counsellorsAddSelected'];
}
$startRow_counsellorsAddSelected = $pageNum_counsellorsAddSelected * $maxRows_counsellorsAddSelected;
mysql_select_db($database_eating01, $eating01);
$query_counsellorsAddSelected = "SELECT counsellorID, first_name, surname, station, contact_details, counselling_address, bio, fees_session, type_of_therapy, county_country, town, postcode, professional_body FROM counsellors";
setQueryBuilderSource($query_counsellorsAddSelected,$WADbSearch2,false);
$query_limit_counsellorsAddSelected = sprintf("%s LIMIT %d, %d", $query_counsellorsAddSelected, $startRow_counsellorsAddSelected, $maxRows_counsellorsAddSelected);
$counsellorsAddSelected = mysql_query($query_limit_counsellorsAddSelected, $eating01) or die(mysql_error());
$row_counsellorsAddSelected = mysql_fetch_assoc($counsellorsAddSelected);
if (isset($_GET['totalRows_counsellorsAddSelected'])) {
$totalRows_counsellorsAddSelected = $_GET['totalRows_counsellorsAddSelected'];
} else {
$all_counsellorsAddSelected = mysql_query($query_counsellorsAddSelected);
$totalRows_counsellorsAddSelected = mysql_num_rows($all_counsellorsAddSelected);
}
$totalPages_counsellorsAddSelected = ceil($totalRows_counsellorsAddSelected/$maxRows_counsellorsAddSelected)-1;
?>
<?php
$queryString_WADAcounsellors = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_WADAcounsellors") == false &&
stristr($param, "totalRows_WADAcounsellors") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_WADAcounsellors = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_WADAcounsellors = sprintf("&totalRows_WADAcounsellors=%d%s", $totalRows_WADAcounsellors, $queryString_WADAcounsellors);
?>
