My second php script (using mysql, elseif and searching)

Hey everyone, just finished this http://www.talkfreelance.com/newproperty.html and http://www.talkfreelance.com/search.html. Tell me what you think!

I'm working on setting up a "sort" function so it can sort the properties in order of bedrooms, price etc. It's driving me nuts though! Anyone have any idea how i can implement this?

I'm basically doing the search like this....

mysql_select_db('talkfreelance_com_-_3'); $query = "select * from property where ".$searchtype." like '%".$searchterm."%'";

Post the source code so we can see how you coded the pages. The sorting thing is easy enough. Change the results.page to use GET instead of POST. Add an optional query to the URL called something like sortby=xxxxx.

Then get the value of sortby using $_GET['sortby'];

Then use a switch statement to alter the msql query.

I won't post the exact code. Instead I'll let you work it out for yourself

Good to see you got it working Your learning php is going quite well.

yes i agree.. now all you need to do is add your scripts to sites/templates

Looks like its going pretty well, keep at it

looking nice !