table.field = > 'VALUE'

[Chris_Evans]

Does anybody know how to put the > symbol into an SQL statement? I can't remember! 🙂

I'm looking to select all numbers that are > '1' for example.

Chris

[bubblenut]

select column from table where column>1

[Chris_Evans]

Ok - that's what I had, so it must be something else, thanks though. Here is the query I am using:

$query = "SELECT homes.id,homes.house,homes.pricemin,homes.pricemax,details.beds,details.type,details.newdev,details.agent,floors.house FROM homes WHERE homes.id=floors.house,homes.id=details.house,".$sqlbeds."homes.pricemin > 1,homes.pricemax > 2 ORDER BY date DESC LIMIT ".$limit;

Error in SQL query at line 1.

I can't seem to find it, probably something obvious. Thanks in advance,

Chris

[bubblenut]

What do you get if you echo the query before you run it? It may be that the variables you are using do not have the expected values in them.

[Chris_Evans]

Well, wasn't there but thanks because I just realised that I missed out the table names in FROM! 🙂 Anyhow, there is still an error left somewhere! 🙂 Current syntax is as follows:

$query = "SELECT homes.id,homes.house,homes.pricemin,homes.pricemax,details.beds,details.type,details.newdev,details.agent,floors.house FROM homes,details,floors WHERE (homes.id=floors.house,homes.id=details.house) ORDER BY date DESC LIMIT ".$limit;

I've tried removing all the way back to home.id=details.house and I still get an error.

Thanks,

Chris

[Chris_Evans]

Ok, I've tested it a bit further. Another fault was that I had LIMIT .$limit on the end when $limit had no value.

Ok. It now appears that it is the way I use the , to seperate the values as it works fine with just one WHERE clause.

[bubblenut]

There where clause is logical ie you need to say either && (AND) or || (OR) when combining conditions. If you want both conditions to be true for the row to be returned then your where clause needs to be WHERE homes.id=floors.house && homes.id=details.house
HTH
Bubble

[Chris_Evans]

Ok, another error sorted. Thanks for that! 🙂 Great help.

[Chris_Evans]

Finished. Works perfectly now, thanks! 🙂

$query = "SELECT homes.id,homes.house,homes.pricemin,homes.pricemax,details.beds,details.type,details.newdev,details.agent,floors.house FROM homes,details,floors WHERE homes.id=floors.house AND homes.id=details.house AND ".$sqlbeds."homes.pricemin > '1' AND homes.pricemax > '2' ORDER BY homes.date DESC LIMIT 1";

Chris