Results 1 to 2 of 2

Thread: search for multiple table

  1. #1
    Join Date
    Mar 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default search for multiple table

    i have three table (user,movie,music) which all have an colum(country) and
    i want to retreive country name as same time
    my query is like this but it doesn't work any idea please..


    $QuerySelect="SELECT * FROM movie,music,user WHERE `country` LIKE'%$name%'";

  2. #2
    Join Date
    May 2007
    Location
    By the beach
    Posts
    23
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    Please place a white space after LIKE:

    Before:
    $QuerySelect="SELECT * FROM movie,music,user WHERE `country` LIKE'%$name%'";

    After:
    $QuerySelect="SELECT * FROM movie,music,user WHERE `country` LIKE '%$name%'";

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
  •