custom database search

  • nic1190

    (@nic1190)


    17 years, 11 months ago

    I am wordpressafying a site which currently has a “search for a photographer” function, this allows users to search for a photographer by “speciality” “name” and “location” maintained by a mySQL DB. What I want to do is set up a custom search based on the information gathered from the wordpress users information which would mean extending those fields to include location and speciallity.

    I’ve search high and low for anyone who has done something similar but have yet to find any documentation, if any one could point me in the right direction, or even let me know if it could be done. I’m guessing it’s way over my head coding wise so I may pay somoene to do it but need to know where to start.

    I could integrate the old DB and search but that then means maintaining two DB with the same information.

Viewing 1 replies (of 1 total)
  • gspx

    (@gspx)

    17 years, 11 months ago

    there is a plugin called wp-folksonomy that might be able to help you tag images to their photographers, otherwise if each photographer has his/her own username, you could make a search that does something like this

    SELECT * FROM users WHERE NAME="name"
    that gives you the row with their ID

    Then you can search teh posts db with their ID number.
    It’s a heavy query though, may well not be the best way.

Viewing 1 replies (of 1 total)

The topic ‘custom database search’ is closed to new replies.

Tags