multiple table queries? Please help

[renfley]

So here is the deal

i am querying one table withing the database and displaying them within another view.

 

if( strtolower( $language->_lang ) == "fr-fr" )

$query = "Select id,idea_1 as title, challenge_id as challenge, is_anonymous from " .

$db->nameQuote('#__table1_ideas') . " where userid = '" . $user->id . "' and is_draft =  '0'";

else

 

Prob is i also need challenge title from another table If anyone can help me out that would be great

 

Thanks in advance

[Maq]

You need to join the other table.  What's the actual problem?

[renfley]

I havnt a clue how LOL i know it is a very Very Simple solution but i just cant figure it out for the life of me LOL

[Maq]

Post your table definitions, what you want to extract & join on.  We can help you with your syntax & logic.  Have a look at this first - http://dev.mysql.com/doc/refman/5.0/en/join.html

[renfley]

 

if( strtolower( $language->_lang ) == "fr-fr" )

        $query = "Select id,idea_1 as title, challenge_id as challenge, is_anonymous from " .

        $db->nameQuote('#__table1_ideas') . " where userid = '" . $user->id . "' and is_draft =  '0'";

      else

 

i want to extract from table2 the challenge_title based on the challenge_id pull from table one if that makes sense 

 

Again thanks man