I am no programmer and hired someone to assist me.
He made a mistake in the code somewhere and I am to stupid to find it.
He is on leave until the 11th!
Any help will be great!

It is a booking page and displays the business name address and other information. When you request a booking, it displays the wrong business and also email the wrong business name.

You can see this by going to: http://www.kalahariinfo.com/directory.php?subcategory=6

Click on the request a booking quote link next to the name James Guest House.
You will see it on the request form it says Global Communications.

Any Idea how to fix this?

Please, Please I have to get this right


Here is the code for the booking page:


<div class="orangebar">
<div class="orangebar_l"><div class="orangebar_r" style="text-align:left;">
<div class="orangebar_links" style="width:200px;padding:5px 15px 0;">
<img src="images/pic_1.jpg" style="float:right;margin:0;padding:0;" />
<a style="padding:30px 0 0 3px;width;" href="<?=$directory['file']?>?subcategory=<?=$_REQUEST['subcategory']?>">Back to Directory</a>


</div>

<p style="margin:0;padding:22px;font-size:36px;font-weight:bold;">


Booking Form



</p>
</div></div>
</div>

</div>

<div id="page_title_box"><p>Complete the form to arrange a booking / make an inquiry</p></div>
<div id="page"><div id="page_inner">

<?
if(is_array($businesses)){
foreach($businesses as $business){
if($business['businessID']==$bookBusinessID){
?>
<div class="business_listing">
<h2><?=stripslashes($business['businessName'])?>
</h2>
<div class="address_photos">
<div class="photos"><?=stripslashes($business['businessPhotos'])?></div>
<div class="address"><?=stripslashes($business['businessAddress'])?></div>
<br style="clear:both;" />
</div>
<p><?=stripslashes($business['businessDescription'])?></p>
</div>
<?php
}
}
}
?>

<h2>Booking Form</h2>

<p>Please complete this form to arrange a booking with <?=stripslashes($business['businessName'])?>, or simply make an enquiry. <br />Alternatively, <a href="<?=$directory['file']?>?subcategory=<?=$_REQUEST['subcategory']?>">click here to return to <?=$subcategory?></a>.</p>

<p>Please complete all required fields, these are marked with a red asterisk <span class="required">*</span>.</p>

<br />

<form class="form_apply" method="post" action="<?=$_SERVER['REQUEST_URI']?>" enctype="multipart/form-data">
<input type="hidden" name="Business_Name" value="<?=$business['businessName']?>" />

<label for="Booking_Name">Name <span class="required">*</span></label><input type="text" class="text" name="Booking_Name" id="Booking_Name" value="<?=stripslashes($booking['bookingName'])?>" /><br />
<label for="Booking_Surname">Surname <span class="required">*</span></label><input type="text" class="text" name="Booking_Surname" id="Booking_Sirname" value="<?=stripslashes($business['bookingSirname'])?>" /><br />
<label for="Booking_Address">Address <span class="required">*</span></label><input type="text" class="text" name="Booking_Address" id="Booking_Address" value="<?=stripslashes($business['bookingAddress'])?>" /><br />
<label for="Booking_City">City <span class="required">*</span></label><input type="text" class="text" name="Booking_City" id="Booking_City" value="<?=stripslashes($business['bookingCity'])?>" /><br />
<label for="Booking_Code">Code <span class="required">*</span></label><input type="text" class="text" name="Booking_Code" id="Booking_Code" value="<?=stripslashes($business['bookingCode'])?>" /><br />
<label for="Booking_Contact_Number">Contact Number <span class="required">*</span></label><input type="text" class="text" name="Booking_Contact_Number" id="Booking_Contact_Number" value="<?=stripslashes($business['bookingContactNumber'])?>" /><br />

<br />

<?
// DISPLAY BOOKING FORM
if($parentCategory[0] == 3 || $parentCategory[0] == 33){
// DISPLAY BOOKING FORM
?>

<label for="bookingFromDay">Booking From (DD/MM/YYYY)<span class="required">*</span></label>
<select name="bookingFromDay">
<?
for($i=1;$i<32;$i++){
if($i==date('d')){
$selected = "selected=\"selected\"";
}else{
$selected = "";
}
echo "<option value=\"$i\"$selected>$i</option>";
}
?>
</select>
&nbsp;-&nbsp;
<select name="bookingFromMonth">
<?
for($i=1;$i<13;$i++){
if($i==date('m')){
$selected = "selected=\"selected\"";
}else{
$selected = "";
}
echo "<option value=\"$i\"$selected>$i</option>";
}
?>
</select>
&nbsp;-&nbsp;
<select name="bookingFromYear">
<?
for($i=date('Y');$i<date('Y')+5;$i++){
if($i==date('Y')){
$selected = "selected=\"selected\"";
}else{
$selected = "";
}
echo "<option value=\"$i\"$selected>$i</option>";
}
?>
</select>


<br /><br />




<label for="bookingFromDay">Booking To (DD/MM/YYYY)<span class="required">*</span></label>
<select name="bookingToDay">
<?
for($i=1;$i<32;$i++){
if($i==date('d')){
$selected = "selected=\"selected\"";
}else{
$selected = "";
}
echo "<option value=\"$i\"$selected>$i</option>";
}
?>
</select>
&nbsp;-&nbsp;
<select name="bookingToMonth">
<?
for($i=1;$i<13;$i++){
if($i==date('m')){
$selected = "selected=\"selected\"";
}else{
$selected = "";
}
echo "<option value=\"$i\"$selected>$i</option>";
}
?>
</select>
&nbsp;-&nbsp;
<select name="bookingToYear">
<?
for($i=date('Y');$i<date('Y')+5;$i++){
if($i==date('Y')){
$selected = "selected=\"selected\"";
}else{
$selected = "";
}
echo "<option value=\"$i\"$selected>$i</option>";
}
?>
</select>
<br />

<br />


<label for="Number_of_Persons">Number of Persons <span class="required">*</span></label><input type="text" class="text" name="Number_of_Persons" id="Number_of_Persons" /><br />

<br />

<label for="Special_Needs_Requirements">Special Needs Requests</label><textarea name="Special_Needs_Requirements" id="Special_Needs_Requirements" style="width:400px;height:100px;"></textarea><br />


<?
// DISPLAY STANDARD CONTACT FORM
}else{
// DISPLAY STANDARD CONTACT FORM
?>







<?
// END IF
}
// END IF
?>

<br />

<label for="Comments">Comments / Enquiry</label><textarea name="Comments" id="Comments" style="width:400px;height:150px;"></textarea><br />


<br /><br />

<label for="null">&nbsp;</label>
<input type="button" name="cancel" value="Cancel" onclick="location.href='<?=$directory['file']?>?subcategory=<?=$_REQUEST['subcategory']?>';" style="margin-right:5px;">
<input type="submit" value="Send Enquiry" />
<br />
</form>

<br style="clear:both;" />

The problem isn't in the form code. It is in the previous page.

Hi

Thanks for coming back to me. I don't know which is the previous page. I think it might be this one then:

Here is the code:

<div class="orangebar">
<div class="orangebar_l"><div class="orangebar_r" style="text-align:left;">
<div class="orangebar_links" style="width:200px;padding:5px 15px 0;">
<img src="images/pic_1.jpg" style="float:right;margin:0;padding:0;" />
<a style="padding:30px 0 0 3px;width;" href="<?=$directory['file']?>">Back to Directory</a>


</div>

<p style="margin:0;padding:22px;font-size:36px;font-weight:bold;">

<?
if($search){
echo "Search Results";
}else{
echo $subcategory;
}
?>


</p>
</div></div>
</div>

</div>

<div id="page_title_box"><p>
<?
if($search){
echo "Search Results for '".$search."'";
}else{
echo "Listings";
}
?>
</p></div>
<div id="page"><div id="page_inner">
<?php
if(is_array($businesses)){
foreach($businesses as $business){
?>
<div class="business_listing">
<h2><?=stripslashes($business['businessName'])?>
<?if($business['businessBookings']){?>
<span class="booking_link">(<a href="<?=$directory['file']?>?subcategory=<?=$_REQUEST['subcategory']?>&bookBusinessID=<?=$business['businessID']?>">Request a booking/quote</a>)</span>
<?}?>
</h2>
<div class="address_photos">
<div class="photos"><?=stripslashes($business['businessPhotos'])?></div>
<div class="address"><?=stripslashes($business['businessAddress'])?></div>
<br style="clear:both;" />
</div>
<p><?=stripslashes($business['businessDescription'])?></p>
</div>
<?php
}

}else{
echo "<br />No listings found, please <a href=\"".$directory['file']."\">go back to the main directory page</a>. Or <a href=\"".$directory['file']."?apply=1\">click here to add your business to the directory</a><br /><br /><br />";
}
?>

And this is the one before that one:

<div class="orangebar">
<div class="orangebar_l"><div class="orangebar_r" style="text-align:left;">
<div class="orangebar_links" style="width:200px;padding:5px 15px 0;">
<img src="images/pic_1.jpg" style="float:right;margin:0;padding:0;" />
<a style="padding:30px 0 0 3px;width;" href="<?=$directory['file']?>">Back to Directory</a>


</div>

<p style="margin:0;padding:22px;font-size:36px;font-weight:bold;"><?=$category?></p>
</div></div>
</div>

</div>

<div id="page_title_box"><p>Categories</p></div>
<div id="page"><div id="page_inner">

<br />
<?php
if(is_array($subcategories)){
foreach($subcategories as $subcategory){
echo "<a class=\"subcategory\" href=\"".$directory['file']."?subcategory=".$subcategory['subcategoryID']."\">".$subcategory['subcategoryName']." (".$subcategory['businessCount']." listings)</a><br /><br />";
}

}else{
echo "<br />No subcategories found, please <a href=\"".$directory['file']."\">go back to the main directory page</a>.<br /><br /><br />";
}
?>

When I click on Request a booking/quote near to James Guest House, I get to the page with booking form for James Guest House

Well there doesn't appear to be anywhere in any of the code that actually sets the arrays and populates them.
Unless I'm missing something blindingly obvious.


And BTW;

Click on the request a booking quote link next to the name James Guest House.
You will see it on the request form it says Global Communications.

For me, it says Pieter's Business,

Thanks you guys. There is a lot of php files and I don't know which one does what.
Is there a sting I can search for to determine the right file? In the mean time here is another I think that contains the STUFF!

Code:
<div class="orangebar">
<div class="orangebar_l"><div class="orangebar_r">
<div class="orangebar_links">
<a href="<?=$directory['file']?>?apply=1">Add Your Business</a>
<a href="contactus.htm">Contact Us</a>
<a href="help.htm">Help</a>
</div>
<img src="images/pic_1.jpg" class="glass" />
<div class="orangebar_search">
<form method="post" name="searchForm" action="<?=$directory['file']?>">
<input type="text" class="search_text" name="search" value="<?=$search?>" />
<input type="image" class="search_button" src="images/button.jpg" />
<label for="search_town">Select Your Town:</label>
<select name="search_town" id="search_town">
<option value="">All Towns</option>
<?
connect();
$sql = "SELECT * FROM town ORDER BY townName ASC";
$result = mysql_query($sql);
while($town = mysql_fetch_array($result)){
echo "<option value=\"".$town['townName']."\">".$town['townName']."</option>";
}
mysql_close();
?>
<option value="Other">Other</option>
</select>
</form>
</div>
</div></div>
</div>

</div>

<div id="page_title_box"><p>Business Directory organised by category</p></div>
<div id="page"><div id="page_inner">

<?
$noCategories = count($categories);
$noColumns = 4;
$categoriesPerColumn = round($noCategories / $noColumns);

// First Div Starts
echo "<div class=\"category_column\"><ul>";

$i=1;
$c=2;

foreach($categories as $category){

echo "<li><a href=\"".$directory['file']."?category=".$category['categoryID']."\">".$category['categoryName']."</a></li>";

if($i==$categoriesPerColumn && $c!=$noColumns+1){
// Div Changeover
echo "</ul><br style=\"clear:both;\" /></div>";

echo "\n<div class=\"category_column border_left\"><ul>";

$i=0;
$c++;
}

$i++;

}

// Last Div Ends
echo "</ul><br style=\"clear:both;\" /></div>";
?>
<br style="clear:both;" />

Sorry wrong file!

Here it is, I found it:

<?php
session_start();

// CONFIGURATION STARTS
require_once('../config.php');
// CONFIGURATION ENDS

$category = addslashes($_REQUEST['category']) ? getCategory(addslashes($_REQUEST['category'])) : 0;
$subcategory = addslashes($_REQUEST['subcategory']) ? getSubcategory(addslashes($_REQUEST['subcategory'])) : 0;
$search = trim($_POST['search']) ? addslashes(trim($_POST['search'])) : addslashes(trim($_REQUEST['search']));
$apply = $_REQUEST['apply'];
$admin = $_REQUEST['admin'];
$page = $_REQUEST['page'] ? $_REQUEST['page'] : 1;

// FUNCTIONS

function connect() {

global $directory;
$db = mysql_connect($directory['databaseHost'], $directory['databaseUser'], $directory['databasePass']) or die('Unable to connect to the database server');
mysql_select_db($directory['databaseName'],$db) or die('Unable to select database on given server');

}

function sendEnquiry($formData){
global $directory;

$headers .= "From: Web Enquiry/Booking <noreply@kalahariinfo.com>\n";
$headers .= "Content-Type: text/plain; charset=iso-8859-1\n";

$mailSubject = "Web Enquiry/Booking for ".$formData['businessName'];
$mailBody = "A new web enquiry/booking has arrived for ".$formData['businessName'].":\n\n";
if($formData['bookingFromDay']){
$formData['Booking_From_Date'] = $formData['bookingFromDay']."/".$formData['bookingFromMonth']."/".$formData['bookingFromYear'];
$formData['bookingFromDay'] = "";
$formData['bookingFromMonth'] = "";
$formData['bookingFromYear'] = "";
$formData['Booking_To_Date'] = $formData['bookingToDay']."/".$formData['bookingToMonth']."/".$formData['bookingToYear'];
$formData['bookingToDay'] = "";
$formData['bookingToMonth'] = "";
$formData['bookingToYear'] = "";
}
foreach($formData as $key=>$value){
if($value){
$mailBody.=str_replace('_',' ',$key).": ".$value."\n";
}
}
$sent = mail($directory['adminEmail'],$mailSubject,stripslashes($mailBody),$headers);

if($sent){
return TRUE;
}else{
return FALSE;
}
}

function getCategory($category){
connect();

$sql = "SELECT * FROM category WHERE categoryID=$category";
$result = mysql_query($sql);

if(mysql_num_rows($result)){
$categoryRow = mysql_fetch_array($result);
return $categoryRow['categoryName'];
}else{
return FALSE;
}
mysql_close();
}

function getSubcategory($subcategory){
connect();
$sql = "SELECT * FROM subcategory WHERE subcategoryID=$subcategory";
$result = mysql_query($sql);
if(mysql_num_rows($result)){
$subcategoryRow = mysql_fetch_array($result);
return $subcategoryRow['subcategoryName'];
}else{
return FALSE;
}
mysql_close();
}

function getParentCategory($subcategory){
connect();

$sql = "SELECT category.categoryName, category.categoryID FROM category
INNER JOIN subcategory ON subcategory.categoryID=category.categoryID
WHERE subcategory.subcategoryID=$subcategory";
$result = mysql_query($sql);

if(mysql_num_rows($result)){
$categoryRow = mysql_fetch_array($result);
$parentCategory[] = $categoryRow['categoryID'];
$parentCategory[] = $categoryRow['categoryName'];
return $parentCategory;
}else{
return FALSE;
}
mysql_close();
}

function listCategories(){
connect();
//$sql = "SELECT DISTINCT category.categoryID, category.categoryName FROM category
// INNER JOIN subcategory ON category.categoryID=subcategory.categoryID
// INNER JOIN business_subcategory ON business_subcategory.subcategoryID=subcategory.sub categoryID
// INNER JOIN business ON business.businessID=business_subcategory.businessI D
// WHERE businessActive=1";

$sql = "SELECT category.categoryID, category.categoryName FROM category";

$result = mysql_query($sql);
if(mysql_num_rows($result)){
while($categories = mysql_fetch_array($result)){
$categoryRow[] = $categories;
}
return $categoryRow;
}else{
return FALSE;
}
mysql_close();
}

function listSubcategories($categoryID){
connect();
//$sql = "SELECT DISTINCT subcategory.subcategoryID, subcategory.subcategoryName FROM subcategory
// INNER JOIN business_subcategory ON business_subcategory.subcategoryID=subcategory.sub categoryID
// INNER JOIN business ON business.businessID=business_subcategory.businessI D
// WHERE businessActive=1
// AND subcategory.categoryID=$categoryID";
$sql = "SELECT DISTINCT subcategory.subcategoryID, subcategory.subcategoryName, COUNT(business.businessID) AS businessCount FROM subcategory
LEFT JOIN business_subcategory ON subcategory.subcategoryID=business_subcategory.sub categoryID
LEFT JOIN business ON business.businessID=business_subcategory.businessI D AND business.businessActive=1
WHERE subcategory.categoryID=$categoryID
GROUP BY subcategory.subcategoryID";
$result = mysql_query($sql);
if(mysql_num_rows($result)){
while($categories = mysql_fetch_array($result)){
$categoryRow[] = $categories;
}
return $categoryRow;
}else{
return FALSE;
}
mysql_close();
}

function listBusinesses($subcategory=0, $search=""){
global $directory;
connect();

if($subcategory>0){

$sql = "SELECT * FROM business
INNER JOIN business_subcategory ON business_subcategory.businessID=business.businessI D
WHERE business_subcategory.subcategoryID=$subcategory
AND business.businessActive=1";

}elseif($search){

$sql = "SELECT * FROM business
WHERE business.businessActive=1";

if($_POST['search_town']){
$sql .= " AND business.businessCity LIKE '%".addslashes($_POST['search_town'])."%'";
}

$sql .= " AND business.businessName LIKE '%".$search."%'";

}

$result = mysql_query($sql);
if(mysql_num_rows($result)){
while($business = mysql_fetch_array($result)){

// Format Address
$businessAddress = "";
$businessAddress .= trim($business['businessAddress1']) ? trim($business['businessAddress1'])."<br />" : "";
$businessAddress .= trim($business['businessAddress2']) ? trim($business['businessAddress2'])."<br />" : "";
$businessAddress .= trim($business['businessCity']) ? trim($business['businessCity'])."<br />" : "";
$businessAddress .= trim($business['businessCode']) ? trim($business['businessCode'])."<br />" : "";
$businessAddress .= trim($business['businessTel']) ? "Tel: ".trim($business['businessTel'])."<br />" : "";
$businessAddress .= trim($business['businessFax']) ? "Fax: ".trim($business['businessFax'])."<br />" : "";
$businessAddress .= trim($business['businessCell']) ? "Cell: ".trim($business['businessCell'])."<br />" : "";
$businessAddress .= trim($business['businessEmail']) ? "Email: <a href=\"mailto:".trim($business['businessEmail'])."\">".trim($business['businessEmail'])."</a><br />" : "";
$businessAddress .= trim($business['businessWebsite']) ? "Website: <a target=\"_blank\" href=\"http://".trim($business['businessWebsite'])."\">".trim($business['businessWebsite'])."</a><br />" : "";

$business['businessAddress'] = $businessAddress;

// Format Photos

$businessPhotos = "";
$businessPhotos .= trim($business['businessPhoto1']) ? "<a href=\"".$directory['imageFolder']."originals/".trim($business['businessPhoto1'])."\" target=\"blank\"><img src=\"".$directory['imageFolder'].trim($business['businessPhoto1'])."\" alt=\"".$business['businessName']." Photo 1\" /></a>" : "";
$businessPhotos .= trim($business['businessPhoto2']) ? "<a href=\"".$directory['imageFolder']."originals/".trim($business['businessPhoto2'])."\" target=\"blank\"><img src=\"".$directory['imageFolder'].trim($business['businessPhoto2'])."\" alt=\"".$business['businessName']." Photo 2\" /></a>" : "";
$businessPhotos .= trim($business['businessPhoto3']) ? "<a href=\"".$directory['imageFolder']."originals/".trim($business['businessPhoto3'])."\" target=\"blank\"><img src=\"".$directory['imageFolder'].trim($business['businessPhoto3'])."\" alt=\"".$business['businessName']." Photo 3\" /></a>" : "";

$business['businessPhotos'] = $businessPhotos;

$businessRow[] = $business;
}
return $businessRow;
}else{
return FALSE;
}
mysql_close();
}

function addBusiness($business){
global $directory;

// Upload Images

if($_FILES['businessPhoto1']['size']>0){
$businessPhoto1 = uploadImage($_FILES['businessPhoto1']);
}
if($_FILES['businessPhoto2']['size']>0){
$businessPhoto2 = uploadImage($_FILES['businessPhoto2']);
}
if($_FILES['businessPhoto3']['size']>0){
$businessPhoto3 = uploadImage($_FILES['businessPhoto3']);
}

if(!$directory['logged_in']){
$business['businessActive']=0;
}

connect();
$sql = "INSERT INTO business (businessActive,
businessBookings,
businessName,
businessAddress1,
businessAddress2,
businessCity,
businessCode,
businessDescription,
businessTel,
businessFax,
businessCell,
businessContactPerson,";

if($businessPhoto1){
$sql .= "businessPhoto1,";
}
if($businessPhoto2){
$sql .= "businessPhoto2,";
}
if($businessPhoto3){
$sql .= "businessPhoto3,";
}

$sql .= "businessWebsite,
businessEmail)

VALUES (

'".$business['businessActive']."',
'".$business['businessBookings']."',
'".$business['businessName']."',
'".$business['businessAddress1']."',
'".$business['businessAddress2']."',
'".$business['businessCity']."',
'".$business['businessCode']."',
'".$business['businessDescription']."',
'".$business['businessTel']."',
'".$business['businessFax']."',
'".$business['businessCell']."',
'".$business['businessContactPerson']."',";

if($businessPhoto1){
$sql .= "'".$businessPhoto1."',";
}
if($businessPhoto2){
$sql .= "'".$businessPhoto2."',";
}
if($businessPhoto3){
$sql .= "'".$businessPhoto3."',";
}

$sql .= "'".$business['businessWebsite']."',
'".$business['businessEmail']."'

)";


$result = mysql_query($sql);

if($result){
$sql = "INSERT INTO business_subcategory (subcategoryID, businessID) VALUES ('".$business['businessSubcategory']."','".mysql_insert_id()."')";
$result = mysql_query($sql);
return TRUE;
}else{
return FALSE;
}
mysql_close();
}

function uploadImage($imageFile){
global $directory;

$imageFileTypes = array('image/gif','image/pjpeg','image/jpeg','image/png');
$imageThumbHeight = 100;
if(in_array($imageFile['type'],$imageFileTypes)){
$imageFileType = $imageFile['type'];
$imageFileExtension = strtolower(strrchr($imageFile['name'], '.'));

srand((double)microtime()*1000000);
$rnd = rand(0,100);
$imageFileName = time().$rnd;



$copy = copy($imageFile['tmp_name'], $directory['imageFolder'].'originals/'.$imageFileName.$imageFileExtension);



if($copy){

if($imageFileType=="image/gif"){
$imageSaved = imagecreatefromgif($directory['imageFolder'].'originals/'.$imageFileName.$imageFileExtension);
}elseif($imageFileType=="image/jpg" || $imageFileType=="image/pjpeg" || $imageFileType=="image/jpeg"){
$imageSaved = imagecreatefromjpeg($directory['imageFolder'].'originals/'.$imageFileName.$imageFileExtension);
}elseif($imageFileType=="image/png"){
$imageSaved = imagecreatefrompng($directory['imageFolder'].'originals/'.$imageFileName.$imageFileExtension);
}

$imageSavedWidth = imagesx( $imageSaved );
$imageSavedHeight = imagesy( $imageSaved );




// Create Thumbnail


$imageThumbWidth = floor( $imageSavedWidth * ( $imageThumbHeight / $imageSavedHeight ) );

$tmp_img = imagecreatetruecolor( $imageThumbWidth, $imageThumbHeight );
imagecopyresampled( $tmp_img, $imageSaved, 0, 0, 0, 0, $imageThumbWidth, $imageThumbHeight, $imageSavedWidth, $imageSavedHeight );
$saveThumb = imagejpeg( $tmp_img, $directory['imageFolder'].$imageFileName.".jpg");

return $imageFileName.".jpg";
}else{
return FALSE;
}
}else{
return FALSE;
}
}

And the last part:

function editBusiness($business){
global $directory;

if($_FILES['businessPhoto1']['size']>0){
$businessPhoto1 = uploadImage($_FILES['businessPhoto1']);
}
if($_FILES['businessPhoto2']['size']>0){
$businessPhoto2 = uploadImage($_FILES['businessPhoto2']);
}
if($_FILES['businessPhoto3']['size']>0){
$businessPhoto3 = uploadImage($_FILES['businessPhoto3']);
}

if(is_numeric($_REQUEST['edit'])){

connect();

$sql = "UPDATE business SET
businessActive='".$business['businessActive']."',
businessBookings='".$business['businessBookings']."',
businessName='".$business['businessName']."',
businessAddress1='".$business['businessAddress1']."',
businessAddress2='".$business['businessAddress2']."',
businessCity='".$business['businessCity']."',
businessCode='".$business['businessCode']."',
businessDescription='".$business['businessDescription']."',
businessTel='".$business['businessTel']."',
businessFax='".$business['businessFax']."',
businessCell='".$business['businessCell']."',
businessContactPerson='".$business['businessContactPerson']."',
businessWebsite='".$business['businessWebsite']."',
businessWebsite='".$business['businessWebsite']."',
businessWebsite='".$business['businessWebsite']."',";

if($businessPhoto1 || $business['businessPhoto1Delete']){
$sql .= "businessPhoto1='".$businessPhoto1."',";
}
if($businessPhoto2 || $business['businessPhoto2Delete']){
$sql .= "businessPhoto2='".$businessPhoto2."',";
}
if($businessPhoto3 || $business['businessPhoto3Delete']){
$sql .= "businessPhoto3='".$businessPhoto3."',";
}

$sql .= "businessEmail='".$business['businessEmail']."' WHERE businessID=".$_REQUEST['edit'];

$result = mysql_query($sql);

if($result){
$sql = "DELETE FROM business_subcategory WHERE businessID=".$_REQUEST['edit'];
$result = mysql_query($sql);
$sql = "INSERT INTO business_subcategory (businessID, subcategoryID) VALUES ('".$_REQUEST['edit']."','".$business['businessSubcategory']."')";
$result = mysql_query($sql);
return TRUE;
}else{
return FALSE;
}

mysql_close();

}else{
return FALSE;
}
}

// AJAX

if(is_numeric($_REQUEST['select_subcategories'])){

connect();
$sql = "SELECT * FROM subcategory WHERE categoryID=".$_REQUEST['select_subcategories']." ORDER BY subcategoryName ASC";
$result = mysql_query($sql);
while($category = mysql_fetch_array($result)){
echo "<option value=\"".$category['subcategoryID']."\">".$category['subcategoryName']."</option>";
}
mysql_close();

die();
}

// RUN

$directory['breadcrumb_start'] = "<a href=\"".$directory['file']."\">Directory</a> &raquo; ";

if($admin){

require_once($directory['includeFolder'].'secure.php');

if(!$directory['logged_in']){

$directory['pageTitle']='Admin Login';
$directory['pageIncludeFile'] = 'directory_login.php';

}else{

$directory['pageIncludeFile'] = 'admin_list.php';
$directory['pageTitle']='Admin List of Businesses';

if($_REQUEST['new']){
// ADD NEW BUSINESS

if($_POST){

foreach ($_POST as $field=>$value)
{
$business[$field] = trim(addslashes($value));
}

$addBusinessComplete = addBusiness($business);

if($addBusinessComplete){
$directory['pageIncludeFile'] = 'admin_list.php';
$directory['pageTitle']='Admin List of Businesses';
}

}else{

$directory['pageIncludeFile'] = 'directory_apply.php';
$directory['pageTitle']='Admin Add New Business';

}

}elseif(is_numeric($_REQUEST['subcategories'])){
// MANAGE SUBCATEGORIES

$directory['pageIncludeFile'] = 'admin_subcategories_list.php';
$directory['pageTitle']='Admin Manage Subcategories';

if($_REQUEST['new_subcategory']){

if($_POST['subcategoryName']){
$subcategoryName = addslashes($_POST['subcategoryName']);
$sql = "INSERT INTO subcategory (subcategoryName,categoryID) VALUES ('".$subcategoryName."','".$_REQUEST['subcategories']."')";
connect();
$resultNew = mysql_query($sql);
mysql_close();
if($resultNew){
$directory['pageIncludeFile'] = 'admin_subcategories_list.php';
$directory['pageTitle']='Admin Manage Subcategories';
}
}else{


$directory['pageIncludeFile'] = 'admin_subcategories_edit.php';
$directory['pageTitle']='Admin Add New Subcategory';

}

}

if($_POST['action']=="Delete" && count($_POST['categoryID'])){
// delete subcategories

connect();
foreach($_POST['categoryID'] as $categoryID){
$sql = "DELETE FROM subcategory WHERE subcategoryID=".$categoryID;
$result = mysql_query($sql);
$sql = "DELETE FROM business_subcategory WHERE subcategoryID=".$categoryID;
$result = mysql_query($sql);
}
mysql_close();

}

if(is_numeric($_REQUEST['id'])){

if($_POST['action']=='Save Subcategory'){

$subcategoryName = addslashes($_POST['subcategoryName']);

connect();
$sql = "UPDATE subcategory SET subcategoryName='".$subcategoryName."' WHERE subcategoryID=".$_REQUEST['id'];

$resultUpdateCat = mysql_query($sql);
mysql_close();

if($resultUpdateCat){
$directory['pageIncludeFile'] = 'admin_subcategories_list.php';
$directory['pageTitle']='Admin Manage Subcategories';
}

}else{

connect();
$sql = "SELECT subcategoryName FROM subcategory WHERE subcategoryID=".$_REQUEST['id'];
$result = mysql_query($sql);
if(mysql_num_rows($result)){
$subcategory = mysql_fetch_array($result);
$directory['pageIncludeFile'] = 'admin_subcategories_edit.php';
$directory['pageTitle']='Admin Manage Categories';
}
mysql_close();

}


}


}elseif($_REQUEST['categories']){
// MANAGE CATEGORIES

$directory['pageIncludeFile'] = 'admin_categories_list.php';
$directory['pageTitle']='Admin Manage Categories';

if($_REQUEST['new_category']){

if($_POST['categoryName']){
$categoryName = addslashes($_POST['categoryName']);
$sql = "INSERT INTO category (categoryName) VALUES ('".$categoryName."')";
connect();
$resultNew = mysql_query($sql);
mysql_close();
if($resultNew){
$directory['pageIncludeFile'] = 'admin_categories_list.php';
$directory['pageTitle']='Admin Manage Categories';
}
}else{


$directory['pageIncludeFile'] = 'admin_categories_edit.php';
$directory['pageTitle']='Admin Add New Category';

}

}


if($_POST['action']=="Delete" && count($_POST['categoryID'])){
// delete categories

connect();
foreach($_POST['categoryID'] as $categoryID){
$sql = "DELETE FROM category WHERE categoryID=".$categoryID;
$result = mysql_query($sql);
$sql = "DELETE FROM subcategory WHERE categoryID=".$categoryID;
$result = mysql_query($sql);
}
mysql_close();

}


if(is_numeric($_REQUEST['id'])){

if($_POST['action']=='Save Category'){

$categoryName = addslashes($_POST['categoryName']);

connect();
$sql = "UPDATE category SET categoryName='".$categoryName."' WHERE categoryID=".$_REQUEST['id'];

$resultUpdateCat = mysql_query($sql);
mysql_close();


$directory['pageIncludeFile'] = 'admin_categories_list.php';
$directory['pageTitle']='Admin Manage Categories';


}else{

connect();

$sql = "SELECT * FROM category WHERE categoryID=".$_REQUEST['id'];
$result = mysql_query($sql);
if(mysql_num_rows($result)){

$category = mysql_fetch_array($result);
$directory['pageIncludeFile'] = 'admin_categories_edit.php';
$directory['pageTitle']='Admin Edit Category';

}

mysql_close();

}
}

}elseif($_POST['action']=="Delete" && count($_POST['businessID'])){

connect();
foreach($_POST['businessID'] as $businessID){
$sql = "DELETE FROM business WHERE businessID=".$businessID;
$result = mysql_query($sql);
$sql = "DELETE FROM business_subcategory WHERE businessID=".$businessID;
$result = mysql_query($sql);
}
mysql_close();

}elseif($_POST['action']=="Activate" && count($_POST['businessID'])){

connect();
foreach($_POST['businessID'] as $businessID){
$sql = "UPDATE business SET businessActive='1' WHERE businessID=".$businessID;
$result = mysql_query($sql);
}
mysql_close();

}elseif($_POST['action']=="Deactivate" && count($_POST['businessID'])){

connect();
foreach($_POST['businessID'] as $businessID){
$sql = "UPDATE business SET businessActive='0' WHERE businessID=".$businessID;
$result = mysql_query($sql);
}
mysql_close();

}elseif(is_numeric($_REQUEST['edit'])){
// EDIT EXISTING BUSINESS

if($_POST){

foreach ($_POST as $field=>$value)
{
$business[$field] = trim(addslashes($value));
}

$editBusinessComplete = editBusiness($business);

if($editBusinessComplete){
$directory['pageIncludeFile'] = 'admin_list.php';
$directory['pageTitle']='Admin List of Businesses';
}

}else{

connect();
$sql = "SELECT * FROM business WHERE businessID=".$_REQUEST['edit'];
$result = mysql_query($sql);
if(mysql_num_rows($result)){

$business = mysql_fetch_array($result);
$directory['admin_edit'] = 1;
$directory['pageIncludeFile'] = 'directory_apply.php';
$directory['pageTitle']='Edit Business';
}

}

mysql_close();

}elseif(is_numeric($_REQUEST['export']) || is_numeric($_REQUEST['export_bookings'])){

header('Content-Type: application/vnd.ms-excel');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');

connect();

if($_REQUEST['export_bookings']){

$sql = "SELECT business.*, subcategory.subcategoryName, category.categoryName FROM business
LEFT JOIN business_subcategory ON business.businessID=business_subcategory.businessI D
LEFT JOIN subcategory ON business_subcategory.subcategoryID=subcategory.sub categoryID
LEFT JOIN category ON subcategory.categoryID=category.categoryID
WHERE business.businessBookings=1
ORDER BY businessName ASC";

}else{

$sql = "SELECT business.*, subcategory.subcategoryName, category.categoryName FROM business
LEFT JOIN business_subcategory ON business.businessID=business_subcategory.businessI D
LEFT JOIN subcategory ON business_subcategory.subcategoryID=subcategory.sub categoryID
LEFT JOIN category ON subcategory.categoryID=category.categoryID
ORDER BY businessName ASC";

}


echo "<table>
<thead>
<tr>
<th>Name</th>
<th>Address 1</th>
<th>Address 2</th>
<th>City</th>
<th>Zip Code</th>
<th>Category</th>
<th>Description</th>
<th>Telephone</th>
<th>Fax</th>
<th>Cell</th>
<th>Contact Person</th>
<th>Website</th>
<th>Email</th>
</tr>
</thead>

<tbody>";

$result = mysql_query($sql);

while($business = mysql_fetch_array($result)){



echo "<tr>
<td>".$business['businessName']."</td>
<td>".$business['businessAddress1']."</td>
<td>".$business['businessAddress2']."</td>
<td>".$business['businessCity']."</td>
<td>".$business['businessCode']."</td>
<td>".$business['categoryName']." &raquo; ".$business['subcategoryName']."</td>
<td>".$business['businessDescription']."</td>
<td>".$business['businessTel']."</td>
<td>".$business['businessFax']."</td>
<td>".$business['businessCell']."</td>
<td>".$business['businessContactPerson']."</td>
<td>".$business['businessWebsite']."</td>
<td>".$business['businessEmail']."</td>
</tr>";

}


echo "</tbody>
</table>";

mysql_close();

die();

}
}

}elseif($apply){

if($_POST['businessName']){
// Add Business

foreach ($_POST as $field=>$value)
{
$business[$field] = trim(addslashes($value));
}

$addBusinessComplete = addBusiness($business);
}

if($addBusinessComplete){
$directory['pageTitle']='Thankyou';
$directory['pageIncludeFile'] = 'directory_apply_complete.php';
}else{
$directory['pageTitle']='Add Your Business To The Directory';
$directory['pageIncludeFile'] = 'directory_apply.php';
}

}elseif($category){
$subcategories = listSubcategories($_REQUEST['category']);
$directory['breadcrumb'] = $directory['breadcrumb_start'] . "<a href=\"".$directory['file']."?category=".$_REQUEST['category']."\">$category</a>";
$directory['pageIncludeFile'] = 'directory_category.php';
$directory['pageTitle']=$category;
}elseif($subcategory){

$parentCategory = getParentCategory($_REQUEST['subcategory']);
$directory['breadcrumb'] = $directory['breadcrumb_start']
. "<a href=\"".$directory['file']."?category=".$parentCategory[0]."\">".$parentCategory[1]
."</a> &raquo; <a href=\"".$directory['file']."?subcategory=".$_REQUEST['subcategory']."\">$subcategory</a>";


// Subcategory Listings
$businesses = listBusinesses($_REQUEST['subcategory']);
$directory['pageIncludeFile'] = 'directory_subcategory.php';
$directory['pageTitle']=$subcategory;


if(is_numeric($_REQUEST['bookBusinessID'])){
// Booking Form For Business

$bookBusinessID = $_REQUEST['bookBusinessID'];

connect();
$sql = "SELECT * FROM business WHERE businessID=$bookBusinessID";
$result = mysql_query($sql);
if(mysql_num_rows($result)){

//uses $parentCategory[0] to display correct form.
$business = mysql_fetch_array($result);
$directory['pageIncludeFile'] = 'booking_form.php';
$directory['pageTitle']=$subcategory;


if($_POST['Booking_Name']){
$sendIt = sendEnquiry($_POST);
if($sendIt){
$directory['pageIncludeFile'] = 'booking_form_thanks.php';
}
}


}
mysql_close();

}

}elseif($search){
$businesses = listBusinesses(0,$search);
$directory['pageIncludeFile'] = 'directory_subcategory.php';
$directory['pageTitle']='Search Results for \''.$search.'\'';
}else{
$categories = listCategories();
$directory['pageIncludeFile'] = 'directory_home.php';
$directory['pageTitle']='Local Business Directory';
}

require_once($directory['includeFolder'].$directory['pageHeaderFile']);
require_once($directory['includeFolder'].$directory['pageIncludeFile']);
require_once($directory['includeFolder'].$directory['pageFooterFile']);
?>

I guess nobody can solve this then! Thanks for those that did have a look!