Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder stevenmw's Avatar
    Join Date
    Jun 2007
    Location
    OK
    Posts
    497
    Thanks
    27
    Thanked 31 Times in 31 Posts

    mysql_query times two....

    PHP Code:
    $data mysql_query("SELECT * FROM news_posts WHERE upper($field) LIKE'%$find%'"); 
    If I want the above query to select * Form two tables at once would i just seperate them by a period?

    Like so:
    news_posts.comments

  • #2
    Regular Coder
    Join Date
    May 2006
    Location
    Wales
    Posts
    820
    Thanks
    1
    Thanked 82 Times in 79 Posts
    PHP Code:
    $data mysql_query("SELECT * FROM news_posts, comments WHERE upper($field) LIKE'%$find%'"); 


  •  

    Posting Permissions

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