posting search queries within Home page
4 posts by 2 authors in: Forums > CMS Builder
Last Post: May 13, 2009 (RSS)
By HDLLC - May 8, 2009 - edited: May 8, 2009
I'm setting this up for a realty web site.
I have the records loaded for listings - all works fine.
What I want to do is include some sorting of records/listings on the home page.
For instance, I have a spot for each agent's "featured listing". Then I want to show all properties in the state of Iowa (for instance) then show a list of all properties in Missouri. And then a list of all properties we marked as sold.
I have a sample page to view:
http://www.Landandgame.com/index_QUERY.php
Down toward the bottom, I have the properties listed in sections for Iowa and Missouri. What I need to do is be able to just show certain properties in those spaces.
For instance, what I want to be under Iowa would be found on this query:
http://landandgame.com/Hunting-Land-For-Sale-List.php?sold=0&state=Iowa
Any help is greatly appreciated!
Thanks in advance!
--Jeff
Re: [HDLLC] posting search queries within Home page
By ross - May 11, 2009
Thanks for posting!
You'll be able to have lists of your records appear anywhere you like and when you use a "where" clause in your viewer code, you can bring in specific listings.
Basically, you take that second link you sent me and use everything after the ? as part of the "where". Like this:
'where' => "sold = 0 AND state = 'Iowa'",
Just stick that up in your viewer code. We might need to adjust it a bit but that's the basics.
Let me know what you think ;).
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
Re: [ross] posting search queries within Home page
By HDLLC - May 11, 2009
Works like a champ!
Only one question...
What if I am trying to do a listing_agent field search for keywords?
Right now, they have their first and last name as a pulldown list to choose from. So, I want to check the listing_agent table for "Mike Brown" let's say... I was doing this:
http://landandgame.com/Hunting-Land-For-Sale-List.php?listing_agent_keyword=Rod
How do I do the "keyword" part in the where clause?
Thanks!
--Jeff
Re: [HDLLC] posting search queries within Home page
By ross - May 13, 2009
To do keyword searching with SQL, you typcally us the LIKE command:
WHERE something LIKE 'something else'
Now, I am not sure if you'll need to go with that though as I don't quite understand what you are aiming for with this new search.
Did you just want to have some details from the agent that created the listing appear?
Let me know :).
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/