Tricky SQL question ?

[Pellefant]

Hello! 🙂

I need to take data from two(!) tables, if possible.

I do have this code which works fine:

$Query = "SELECT * FROM addressbook WHERE memberid LIKE '$memberid' ORDER BY id;" or die (mysql_error());
$Result = mysql_query($Query) or die("Error: ".mysql_error()." in query: ".$Query);

if( mysql_num_rows( $Result ) == 0 ){
	 echo "Address book is emnty";
}

while($Row=mysql_fetch_array($Result)){	
	print "<B>$Row[orgid]</B><br>";
}

mysql_close($Link);

But instead of print the "orgid" numbers, I would like to print the names of the org(anisations).

The organisation names is in the "organisations" table, with the columnname "orgname", and another column is namned "orgid" (that is the same is as in the code above). orgid is a primary key here I belive.

Hope anyone understands. Feel free to ask if anything is unclear.

Thanks.

[Bunkermaster]

You might want to have a look at the JOIN syntax

[tijger]

hai Pellefant,

you have to do a join on the organisations table.

something like:
SELECT * FROM addressbook as a LEFT JOIN organisations as o ON o.orgid=a.orgid WHERE a.memberid LIKE '$memberid' ORDER BY id;

do a EXPLAIN on this query in mysql to see if you can optimise query. read the mysql manual on SELECT, JOIN and EXPLAIN.

greetings, tijger

[Pellefant]

The solution: 🙂

$Query = "SELECT t1.*, t2.orgname FROM addressbook t1, memberorganisations t2 WHERE t1.orgid = t2.id " or die (mysql_error());

[Bunkermaster]

you're welcome (I guess)