j05hr

November 12, 2009

How can I put ['menu_name'] in the line menu-name div?

 $div = '<div class="menu-name"> ' . $i .'</div><div class="buying-text">';

November 12, 2009

I now have this

while ($row = mysql_fetch_assoc($searchResult)) {
$div = '<div class="menu-name"> ' . $i .'</div><div class="buying-text">';
$div .= $row['content'];
$div .= '</div><div class="image"></div>'

How can I make it so in the menu name I can put ['menu_name'] (like what's happening with buying-text for ['content'])

And also on the menu-name it needs to link to the page with this code

 echo "<a href=\"buying.php?page=" . urlencode($subject["id"]) .

But that's from this function


function public_navigation($sel_subject = null, $sel_page = null) {  
        $subject_set = get_all_subjects();
        // 5. Use returned data
        while ($subject = mysql_fetch_array($subject_set)) { 

/*----*/   
	        
	if(!isset($_GET['page'])) {
        echo "<div class=\"menu-name\">"; echo "<a href=\"buying.php?page=" . urlencode($subject["id"]) .
            "\">{$subject["menu_name"]}</a>";  echo"</div>";
	echo "<div class=\"buying-text\">";  echo "{$subject["content"]}";  echo"</div>"; echo "<div class=\"image\">";     echo"</div>";

	}//

        
        
        }
    }

November 12, 2009

I did that but got an error (not sure if I did it right)

The error is Parse error: parse error in C:\wamp\www\estateagent\search.php on line 51

         while ($row = mysql_fetch_assoc($searchResult)) {
           
	   $div = '<div class="menu-name">Home ' . $i .'</div><div class="buying-text">';
		$div .= $row['house_price'] . '<br />' .  $row['bedrooms'] . '<br />' . $row['propType'] . '<br />';
		$div .= '</div><div class="image"></div>';
		$results[] = $div;
		$i++
         }
      }
   }
}

Also, I don't actually want to display bedrooms price or property type as I only made this to make the search function easier, all of them will be included in the content so i only want it to be for the use of the database to find them. Is that ok to do?

November 12, 2009

I have this code

<?php require_once("includes/connection.php"); ?>
<?php
// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted. 
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT id, house_price, bedrooms, propType FROM subjects WHERE ";
      
      // grab the search types.
      $types = array();
      $types[] = isset($_GET['house_price'])?"`house_price` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['bedrooms'])?"`bedrooms` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['propType'])?"`propType` LIKE '%{$searchTermDB}%'":'';
      
      $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
      
      if (count($types) < 1)
         $types[] = "`bedrooms` LIKE '%{$searchTermDB}%'"; // use the body as a default search if none are checked
      
          $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `house_price` ASC "; // order by title.

      $searchResult = mysql_query($searchSQL) or die("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
      
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['house_price']}<br />{$row['bedrooms']}<br />{$row['propType']}<br /><br />";
            $i++;
         }
      }
   }
}

function removeEmpty($var) {
   return (!empty($var)); 
}
?>
<?php include("includes/header.php"); ?>
   <div id="content">
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="get" action="<?php echo $_SERVER['PHP_SELF'];?>" />
	Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?$searchTerms:''; ?>" /><br />
         Search In:<br />
         Price: <input type="checkbox" name="house_price" value="on" <?php echo isset($_GET['house_price'])?"checked":''; ?> /> | 
	Bedrooms: <input type="checkbox" name="bedrooms" value="on" <?php echo isset($_GET['bedrooms'])?"checked":''; ?> /> | 
         Type of Property: <input type="checkbox" name="propType" value="on" <?php echo isset($_GET['propType'])?"checked":''; ?> /><br />
                 Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?> /> <br /><br />
         <input type="submit" name="submit" value="Search" />
      <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>
  </div>
<?php require("includes/footer.php"); ?>

And I want it to be so when I return the search, it will come up with the results looking like this www.sampleestateagent.com/buying.php

Instead of returning it like this http://sampleestateagent.com/search.php?search=house&propType=on&submit=Search

Which part of my code do I need to change so I can put the divs in there of what it will return?

November 12, 2009

So is there no way for doing this as back end staff will be inputting these prices and when dealing with 6-7 figure numbers it's easy to make a mistake and with commas it breaks it up. If not I can just do what you suggested.

Thanks

November 12, 2009

Ah yeah that would make sense but then I remembered why I set it to varchar, what happens if I want the commas? Or you just can't have them?

November 12, 2009

I thought that too and did it before trying here but it just returns, I presume it's finding the 1's and then 2, 3 etc

1: 100000

4

House

2: 1000000

5+

House

3: 200000

1

House

4: 300000

2

House

November 12, 2009

I'm trying to make a search form on my website and I want it to search by price in ascending order. The problem is it doesn't recognize the bigger number in the right way. I've done this search and this is how it's come back, with a million at the top and then one hundred thousdand?

I think it does it based on the first letter?

How can I make it so it does it by size?

$searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `house_price` ASC "; // order by title.

1: 1,000,000

5+

House

2: 100,000

4

House

3: 200,000

1

House

4: 300,000

2

House

November 11, 2009

It's now working, for future reference what did you change? It looks the same as the one I posted.

Thanks for all your help

November 10, 2009

<?php require_once("includes/session.php"); ?>
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php confirm_logged_in(); ?>
<?php
	if (intval($_GET['subj']) == 0) {
		redirect_to("content1.php");
	}
	if (isset($_POST['submit'])) {
		$errors = array();

		$required_fields = array('menu_name', 'position', 'visible', 'content', 'house_price', 'bedrooms', 'propType');
		foreach($required_fields as $fieldname) {
			if (!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0)) { 
				$errors[] = $fieldname; 
			}
		}
		$fields_with_lengths = array('menu_name' => 30);
		foreach($fields_with_lengths as $fieldname => $maxlength ) {
			if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength) { $errors[] = $fieldname; }
		}

		if (empty($errors)) {
			// Perform Update
			$id = mysql_prep($_GET['subj']);
			$menu_name = mysql_prep($_POST['menu_name']);
			$position = mysql_prep($_POST['position']);
			$visible = mysql_prep($_POST['visible']);
			$content = mysql_prep($_POST['content']);
			$house_price = mysql_prep($_POST['house_price']);
			$bedrooms = mysql_prep($_POST['bedrooms']);
			$propType = mysql_prep($_POST['propType']);

			$query = "UPDATE subjects SET 
						menu_name = '{$menu_name}', 
						position = {$position}, 
						visible = {$visible},
						content = '{$content}',
						house_price = '{$house_price}',
						bedrooms = '{$bedrooms}',
						propType = '{$propType}'
					WHERE id = {$id}";
			$result = mysql_query($query, $connection);
			if (mysql_affected_rows() == 1) {
				// Success
				$message = "The subject was successfully updated.";
			} else {
				// Failed
				$message = "The subject update failed.";
				$message .= "<br />". mysql_error();
			}

		} else {
			// Errors occurred
			$message = "There were " . count($errors) . " errors in the form.";
		}




	} // end: if (isset($_POST['submit']))
?>
<?php find_selected_page();?>
<?php include("includes/header.php"); ?>
<div id="content">
	<h2> Buying Edit Page</h2>
	<br />
	<h5>Edit Subject: <?php echo $sel_subject ['menu_name']; ?></h5>
		<?php if (!empty($message)) {
			echo "<p class=\"messge\">" . $message . "</p>";
		} ?>
		<?php
		// output a list of the fields that had errors
		if (!empty($errors)) {
			echo "<p class=\"errors\">";
			echo "Please review the following fields:<br />";
			foreach($errors as $error) {
				echo " - " . $error . "<br />";
			}
			echo "</p>";
		}
		?>
		<form action="edit_subject.php?subj=<?php echo urlencode($sel_subject['id']);?>" method="post">
			<p>Subject name: 
				<input type="text" name="menu_name" value="<?php echo $sel_subject['menu_name']; ?>" id="menu_name" />
			</p>
			<p>House Price: 
				<input type="text" name="house_price" value="<?php echo $sel_subject['house_price']; ?>" id="house_price" />
			</p>
			<p>Bedrooms: 

					<select name="bedrooms"/>
    <option <?php echo $sel_subject['bedrooms'] == '1!' ? 'selected="selected"' : ''; ?>>1</option>
    <option <?php echo $sel_subject['bedrooms'] == '2!' ? 'selected="selected"' : ''; ?>>2</option>
<option <?php echo $sel_subject['bedrooms'] == '3!' ? 'selected="selected"' : ''; ?>>3</option>
<option <?php echo $sel_subject['bedrooms'] == '4!' ? 'selected="selected"' : ''; ?>>4</option>
<option <?php echo $sel_subject['bedrooms'] == '5+!' ? 'selected="selected"' : ''; ?>>5+</option>
</select>

			</p>
			<p>Type of Property: 
				<select name="propType" />
					<option <?php echo $sel_subject == 'House!' ? 'House"' : ''; ?>>House</option>
					<option <?php echo $sel_subject == 'Bungalow!' ? 'selected="selected"' : ''; ?>>Bungalow</option>
					<option <?php echo $sel_subject == 'Flat!' ? 'selected="selected"' : ''; ?>>Flat</option>
					<option <?php echo $sel_subject == 'Detatched!' ? 'selected="selected"' : ''; ?>>Detatched</option>
					<option <?php echo $sel_subject == 'Semi_detached!' ? 'selected="selected"' : ''; ?>>Semi_Detached</option>
					<option <?php echo $sel_subject == 'Terraced!' ? 'selected="selected"' : ''; ?>>Terraced</option>
				</select>
			</p>
			<p>Edit content:
				<textarea name="content" rows="5" cols="70"><?php echo $sel_subject['content']; ?> </textarea>
				</p>
			<p>Position: 
				<select name="position">
					<?php
						$subject_set = get_all_subjects();
						$subject_count = mysql_num_rows($subject_set);
						// $subject_count + 1 b/c we are adding a subject
						for($count=1; $count <= $subject_count+1; $count++) {
							echo "<option value=\"{$count}\"";
							if ($sel_subject['position'] == $count) {
								echo " selected";
							} 
							echo ">{$count}</option>";
						}
					?>
				</select>
			</p>
			<p>Visible: 
				<input type="radio" name="visible" value="0"<?php 
				if ($sel_subject['visible'] == 0) { echo " checked"; } 
				?> /> No
				 
				<input type="radio" name="visible" value="1"<?php 
				if ($sel_subject['visible'] == 1) { echo " checked"; } 
				?> /> Yes
			</p>
			<input type="submit" name="submit" value="Update Subject" />
			</p>

			<h5 id="link"><a href="delete_subject.php?subj=<?php echo urlencode($sel_subject['id']); ?>" onclick="return confirm('Are you sure?');">Delete Subject</a></h5>
		</form>
		<br />
		<h5 id="link"><a href="edit_page.php?page=<?php echo urlencode($sel_subject['id']); ?>">Edit Page</a></h5>
		<h5 id="link"><a href="content1.php">Cancel</a></h5>
		<h5 id="link"><a href="new_page.php?subj=<?php echo $sel_subject['id']; ?>">+ Add a new page to this subject</a></h5>
<?php


?>
</div>

<?php require("includes/footer.php"); ?>
[code]

November 10, 2009

Still not working, was that a guess that might of made it work or it should of done?

November 10, 2009

It doesn't work but I didn't think you knew what I meant.

Here is the code I've used

<select name="bedrooms"/>
    <option <?php echo $sel_subject == '1!' ? 'selected="selected"' : ''; ?>>1</option>
    <option <?php echo $sel_subject == '2!' ? 'selected="selected"' : ''; ?>>2</option>
    <option <?php echo $sel_subject == '3!' ? 'selected="selected"' : ''; ?>>3</option>
    <option <?php echo $sel_subject == '4!' ? 'selected="selected"' : ''; ?>>4</option>
    <option <?php echo $sel_subject == '5+!' ? 'selected="selected"' : ''; ?>>5+</option>
</select>

Say I've selected 2 and click submit, it saves it which is fine, if I came back to edit it. I want it to say 2 (the last thing you saved it as) but it just says the first option.

November 10, 2009

Yeah that solved that, now is there anyway to make it so the one selected is just highlighted and not added to the top so it had two values?

November 10, 2009

I copy and pasted what you sent last time, is that wrong?

Also for those lists, what should the type be in the database as it's saying Unknown column 'Bungalow' in 'field list'

And You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' propType = 3 WHERE id = 53' at line 7 when I try to use 5+ bedrooms (assuming what I'm using doesn't like the plus sign as 1,2,3 and 4 bedrooms work but 5+ and none of the words work on type of property

November 9, 2009

It's still doing the same with your code

November 9, 2009

<?php require_once("includes/session.php"); ?>
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php confirm_logged_in(); ?>
<?php
	if (intval($_GET['subj']) == 0) {
		redirect_to("content1.php");
	}
	if (isset($_POST['submit'])) {
		$errors = array();

		$required_fields = array('menu_name', 'position', 'visible', 'content', 'house_price', 'bedrooms', 'propType');
		foreach($required_fields as $fieldname) {
			if (!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0)) { 
				$errors[] = $fieldname; 
			}
		}
		$fields_with_lengths = array('menu_name' => 30);
		foreach($fields_with_lengths as $fieldname => $maxlength ) {
			if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength) { $errors[] = $fieldname; }
		}

		if (empty($errors)) {
			// Perform Update
			$id = mysql_prep($_GET['subj']);
			$menu_name = mysql_prep($_POST['menu_name']);
			$position = mysql_prep($_POST['position']);
			$visible = mysql_prep($_POST['visible']);
			$content = mysql_prep($_POST['content']);
			$house_price = mysql_prep($_POST['house_price']);
			$bedrooms = mysql_prep($_POST['bedrooms']);
			$propType = mysql_prep($_POST['propType']);

			$query = "UPDATE subjects SET 
						menu_name = '{$menu_name}', 
						position = {$position}, 
						visible = {$visible},
						content = '{$content}',
						house_price = '{$house_price}',
						bedrooms = {$bedrooms},
						propType = {$propType}
					WHERE id = {$id}";
			$result = mysql_query($query, $connection);
			if (mysql_affected_rows() == 1) {
				// Success
				$message = "The subject was successfully updated.";
			} else {
				// Failed
				$message = "The subject update failed.";
				$message .= "<br />". mysql_error();
			}

		} else {
			// Errors occurred
			$message = "There were " . count($errors) . " errors in the form.";
		}




	} // end: if (isset($_POST['submit']))
?>
<?php find_selected_page();?>
<?php include("includes/header.php"); ?>
<div id="content">
	<h2> Buying Edit Page</h2>
	<br />
	<h5>Edit Subject: <?php echo $sel_subject ['menu_name']; ?></h5>
		<?php if (!empty($message)) {
			echo "<p class=\"messge\">" . $message . "</p>";
		} ?>
		<?php
		// output a list of the fields that had errors
		if (!empty($errors)) {
			echo "<p class=\"errors\">";
			echo "Please review the following fields:<br />";
			foreach($errors as $error) {
				echo " - " . $error . "<br />";
			}
			echo "</p>";
		}
		?>
		<form action="edit_subject.php?subj=<?php echo urlencode($sel_subject['id']);?>" method="post">
			<p>Subject name: 
				<input type="text" name="menu_name" value="<?php echo $sel_subject['menu_name']; ?>" id="menu_name" />
			</p>
			<p>House Price: 
				<input type="text" name="house_price" value="<?php echo $sel_subject['house_price']; ?>" id="house_price" />
			</p>
			<p>Bedrooms: 
				<select name="bedrooms" />
					<option selected><?php echo $sel_subject['bedrooms']; ?></option>
					<option>1</option>
					<option>2</option>
					<option>3</option>
					<option>4</option>
					<option>5+</option>
				</select>
			</p>
			<p>Type of Property: 
				<select name="propType" />
					<option><?php echo $sel_subject['propType']; ?></option>
					<option>House</option>
					<option>Bungalow</option>
					<option>Flat</option>
					<option>Detached</option>
					<option>Semi Detached</option>
					<option>Terraced</option>
				</select>
			</p>
			<p>Edit content:
				<textarea name="content" rows="5" cols="70"><?php echo $sel_subject['content']; ?> </textarea>
				</p>
			<p>Position: 
				<select name="position">
					<?php
						$subject_set = get_all_subjects();
						$subject_count = mysql_num_rows($subject_set);
						// $subject_count + 1 b/c we are adding a subject
						for($count=1; $count <= $subject_count+1; $count++) {
							echo "<option value=\"{$count}\"";
							if ($sel_subject['position'] == $count) {
								echo " selected";
							} 
							echo ">{$count}</option>";
						}
					?>
				</select>
			</p>
			<p>Visible: 
				<input type="radio" name="visible" value="0"<?php 
				if ($sel_subject['visible'] == 0) { echo " checked"; } 
				?> /> No
				 
				<input type="radio" name="visible" value="1"<?php 
				if ($sel_subject['visible'] == 1) { echo " checked"; } 
				?> /> Yes
			</p>
			<input type="submit" name="submit" value="Update Subject" />
			</p>

			<h5 id="link"><a href="delete_subject.php?subj=<?php echo urlencode($sel_subject['id']); ?>" onclick="return confirm('Are you sure?');">Delete Subject</a></h5>
		</form>
		<br />
		<h5 id="link"><a href="edit_page.php?page=<?php echo urlencode($sel_subject['id']); ?>">Edit Page</a></h5>
		<h5 id="link"><a href="content1.php">Cancel</a></h5>
		<h5 id="link"><a href="new_page.php?subj=<?php echo $sel_subject['id']; ?>">+ Add a new page to this subject</a></h5>
<?php


?>
</div>

<?php require("includes/footer.php"); ?>

My header where the main html is..

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Estate Agents</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="stylenew.css" />
<!--[if lte IE 6]>
<style type="text/css">
#page-wrap {display:inline-block;}
.featured {padding: 0px;}
</style>
<![endif]-->
<!--[if lte IE 7]>
<style type="text/css">
#page-wrap {display:inline-block;}
.featured {padding-bottom: 10px;}
</style>
<![endif]-->


</head>
<body>
<div id="page-wrap">
<h1>Estate Agent</h1>
<div id="navigation">
<ul>
<li class="home"><a href="index.php">Home</a></li>
<li class="buying"><a href="buying.php">Buying</a></li>
<li class="selling"><a href="selling.php">Selling</a></li>
<li class="renting"><a href="renting.php">Renting</a></li>
<li class="letting"><a href="letting.php">Letting</a></li>
<li class="contact"><a href="contact.php">Contact</a></li>
</ul>
</div>
<div id="sidebar">
<h3 class="sidebar-text"></h3>
<div id="menu">
<ul>
<li class="home"><a href="index.php">Home</a></li>
<li class="buy"><a href="buying.php">Buying</a></li>
<li class="sell"><a href="selling.php">Selling</a></li>
<li class="renting"><a href="renting.php">Renting</a></li>
<li class="newhomes"><a href="newhomes.php">New Homes</a></li>
<li class="contact"><a href="contact.php">Contact Us</a></li>
<li class="about"><a href="about.php">About Us</a></li>
<li class="location"><a href="location.php">Locations</a></li>
<li class="why"><a href="whyus.php">Why Use Us</a></li>
<li class="mailing"><a href="mailinglist.php">Mailing List</a></li>
</ul>
<div class="featured">
<h3 class="sidebar-text1"></h3>
</div>
<div class="featured-bg">
<a href="home2.php"><img src="pictures/feature-house.jpg" alt="propoftheweek" /></a>
<p>Price: £1.395 000 </p>
<p>5 Bedrooms </p>
<p>Indoor Swimming Pool</p>
<p>Tennis Court</p>
<p>Gym</p>
<p>Double Garage </p>
</div>
</div>
</div>
<div id="flash">
<object type="application/x-shockwave-flash"
data="transition.swf"
width="695" height="215">
<param name="movie" value="transition.swf" />
<param name="quality" value="high"/>
</object>
</div>

November 9, 2009

I'm doing it for bedrooms and now the one that's selected comes up first, but it displayes like this. (Say I selected 3 bedrooms)

Also is <option selected> valid because it's coming up in red on my editor

November 9, 2009

Thanks, yeah that is what I meant and it works, it's what I tried but where I was going wrong was, not putting the PHP in an option tag.

I did it like,

<select name="propType" />
<?php echo $sel_subject['propType']; ?>
<option></option>
<option>House</option>
<option>Bungalow</option>
<option>Flat</option>
<option>Detached</option>
<option>Semi Detached</option>
<option>Terraced</option>
</select>

Makes sense why it wouldn't work now, thanks

November 9, 2009

No, it does have an option for your next birthday. I'll explain what I mean with a text box. You write something in it, you want to change what you've written because you've made a spelling mistake. What you've already is still there when you go to edit it because it's echoed back from the database (with that line of code I posted) how would you echo back the same result with a list box?

November 9, 2009

I think you misunderstood the question. For example if you had a list box with your age in it, when you got a year older, you would need to change it, how would you echo back from the database to have the answer you had from last time. Like in a text box you just put <?php echo $sel_subject['house_price']; ?> in the value and it echos back what you wrote in the textbox in the database. It doesn't work that simply with a listbox.

Sorry for the confusion and not explaining myself properly.

November 9, 2009

On an edit page when you want something to select what a user has previously selected from the database, how would you do this for a List/Menu box? The only way I know how is

<?php echo $sel_subject['house_price']; ?>

This is what I have

<select name="propType" />
<?php echo $sel_subject['propType']; ?>
<option></option>
<option>House</option>
<option>Bungalow</option>
<option>Flat</option>
<option>Detached</option>
<option>Semi Detached</option>
<option>Terraced</option>
</select>

Also is it wrong to leave all the options on this page?

November 9, 2009

That looks really good thanks, the only thing I could see that I additionally want it to do is, if you search for a property between a price bracket, not just one specific price, would that be easy to implement?

November 9, 2009

Thanks for that, I will do that when it's online, is there any ides for the search feature?

November 9, 2009

It's been a long time, it's built so the user can create read update and delete. I'm now at the stage where I need to build the search page for it. I'm basing my site on this so something similar to this http://www.andrewward.co.uk/search.htm

Also, I'm going to be putting it online in a few days, would it be ok to give someone a username and password to login and see if it's ok?

Thanks,

Josh

November 6, 2009

Do you mean remove the other code and use this instead or add this in somewhere? Also is the bracket after the else meant to be a curly brace?

Sign In

j05hr

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by j05hr

Search Database

Search Database

Search Database

Search Database

Search by ASC or DESC

Search by ASC or DESC

Search by ASC or DESC

Search by ASC or DESC

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

List/Menu Box

Estate Agent Website

Estate Agent Website

Estate Agent Website

Function

Browse

Activity

Important Information