SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Addict Shantra's Avatar
    Join Date
    Feb 2001
    Location
    Norway
    Posts
    224
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problems with a search quiry!

    I am having problems with an search quiry for an classifieds script (zClassified).
    The problem is to join 3 different tables and do a search quiry for the result.

    I have made a search form where I have the following fields:

    1. Subject and Description (type=text, name=keywords)
    2. City (type=text, name=city)
    3. Country (type=select, name=country)
    4. Category (type=select, name=category)

    Tables:
    1. ads : user_id, subject, descript ++
    2. user : user_id, country ++
    3. category : root_id, cat_name ++




    $result = mysql_query( "SELECT * FROM ads LEFT JOIN user ON ads.user_id=user.user_id WHERE subject LIKE '%$keywords%' OR descript LIKE '%$keywords%' OR city LIKE '%$city%' AND country = '$country' AND cat_name = '$cat_name' ORDER BY add_date DESC" )or error( mysql_error() );


    This code is all I have been able to make. I am sure there are some mistakes in there

    PS! Sorry for not using the code tags, but I am having problems with the WYSIWYG thing [img]images/smilies/mad.gif[/img]



    Last edited by Shantra; May 7, 2003 at 20:00.


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
  •