Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    33

    Unanswered: Joining two tables

    hi, I'm having trouble joining these two tables. Can someone point out my mistake?

    Code:
    $query = 'SELECT jos_keyword_keys.ID, jos_keyword_keys.Word, '
    	.'jos_keyword_keys.ClientID, jos_keyword_keys.Destination, jos_keyword_keys.StartDate, '
    	.'jos_keyword_keys.EndDate, jos_keyword_keys.StartTime, jos_keyword_keys.EndTime '
    	.'jos_keyword_clients.Client, jos_keyword_clients.ID AS CID, jos_keyword_clients.Contact '
    	.'FROM (jos_keyword_keys AND jos_keyword_clients) WHERE (CID = jos_keyword_keys.ClientID)';
    	
    	$query = mysql_query($query);
    Last edited by Schweppesale; 06-22-09 at 20:12.

  2. #2
    Join Date
    Jun 2009
    Posts
    33
    nvm. i figured it out.

Posting Permissions

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