sql to select Range

[Chris]

How do i insert 2 boxes on page to select for example between 2 Price range for a house price search option (Price from and price to)

[Kayla]

You would need to use the Between function in your sql script.

'select somefile from sometable where price between (whatever) AND (whatever);';

What code do you already have done?

[Chris]

I downloaded the trail version of phpmagic and gave it a test ,my concern was viewing images which i did try and it worked.My plans are to make a Estate agent website showing images ,and a search option on the price column.
This must show the price ,refno,bedrooms,etc.
Is it possible to change edit the sql after the webpages was created.

Thank you

[xacto]

Since you have generated the code you can open the generated files in any text editor.

[Chris]

Thank you
But i still dont now how to put text boxes on the page.

[xacto]

But i still dont now how to put text boxes on the page.

What page are you referring to? Have you seen this (http://www.websitedatabases.com/database-forum/showthread.php?t=345) thread a member posted a long time ago. This may help you somewhat. Or maybe you can simply create some pre-defined filters.