Results 1 to 5 of 5

Thread: Features Listing By State or even city

  1. #1
    Join Date
    Mar 2004
    Location
    Windsor, Ontario, Canada
    Posts
    380

    Default

    Is there a way to have featured listing displayed based on state or even the city.

    Say I have featured listing page just to view all the featured listing but when some one search by state, it will only show the featured listing if it is from the state the search was made on. Same for city. Or even a feature listing search by state and city.

  2. #2
    Join Date
    Apr 2003
    Location
    Charleville / Australia
    Posts
    1,421

    Default

    add to your sql statement for the featured listings printout where state='$state"
    You would of course need to use your own method of obtaining the state to put in place of $state

  3. #3
    Join Date
    Mar 2004
    Location
    Windsor, Ontario, Canada
    Posts
    380

    Default

    Quote Originally Posted by RealtyOne
    add to your sql statement for the featured listings printout where state='$state"
    You would of course need to use your own method of obtaining the state to put in place of $state
    Thanks.

    Can I say where state='$state" AND city='$city'

    to do city.

    Thanks again..

  4. #4
    Join Date
    Apr 2003
    Location
    Charleville / Australia
    Posts
    1,421

    Default

    Sure but you will as i said need to also give it a method of comparison.
    This can be as simple as a text form or you could offer select boxes that are populated with known information.
    You can make it dance to what ever tune you want just play with it a little feed it the tune and see what it does

  5. #5
    Join Date
    Jan 2003
    Posts
    201

    Default

    Can I say where state='$state" AND city='$city'
    I would use "OR" as opposed to "AND", unless you're going to make it required to fill in city and state.

Similar Threads

  1. VOW NAR compliance
    By lostsoul in forum HELP (CLOSED)
    Replies: 2
    Last Post: 09-05-2004, 01:34 PM
  2. Listing Browse By City
    By BarkerWr in forum HELP (CLOSED)
    Replies: 1
    Last Post: 05-08-2004, 10:12 AM
  3. Title Address City State Zip
    By Anonymous in forum HELP (CLOSED)
    Replies: 3
    Last Post: 02-07-2004, 06:39 PM
  4. Couple questions... - ANSWERED
    By hbaker in forum HELP (CLOSED)
    Replies: 12
    Last Post: 11-12-2003, 12:42 AM
  5. Add Listing - State Dropdown
    By chemaster in forum HELP (CLOSED)
    Replies: 0
    Last Post: 07-20-2003, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •