Currently I am installing a real estate search script on my website and am having a few problems.

I am trying to ad a text field search for it, and when I create a query that includes:

PropertyRef = $PropertyRef and do a search without entering a number, it displays and error on the query. It works otherwise, but I need to find a way to be able to search without entering in any info into the text field.

Here is a link to where search_.php is located for further reference:
www.assertivead.com/propertyplus

Would I need to somehow cancel the PropertyRef if the contents "PropertyRef" == "" or something along that lines?

Hi,

I suppose your query looks something like "select ... from ... where propertyref = $propertyref"
When propertyref is empty, it gives "where propertyref = ", which is illegal in sql. The condition using propertyref should not be in the query if propertyref doesn't have a value.

if that is the case, what can I do to get around that and make it legal?

Could I put a die on the PropertyRef somehow?

Use php to dynamically assemble your query string:

PHP Code:


if(!empty($propertyref)) $propertyref = " WHERE propertyref = '".$propertyref."'";

$result = mysql_query("SELECT stuff FROM table".$propertyref); 


That way if propertyref is empty, you get "SELECT stuff FROM table"
If it has a value, say propertyref is 87, it gets set to be 'propertyref=87', and the query gets a where clause.

I am not exactly sure on how to implement that, but could I use part of the function and say someting like

if (!empty($PropertyRef)) {$result = mysql_query("SELECT * FROM $property_table WHERE PropertyRef = $PropertyRef"); }

that seemed to take care of my problem! Thanks for the insight, wouldn't have gotten it without your help

Yeah I think that would achieve the same effect.

I got that to work, but I had to implement a die in order to stop it from listing the page number script. Without it, it says that it had found 13 properties. The only problem is with the die in place, it also cancels the footer include on that page the search is included into (ie search.php has footer.php and search_.php included into the template).

What could I do to set this up so it won't cancel that footer? I have tried a few other functions, but they all either return errors or do the smae thing.

Thnaks!