Hello,

I'm trying to learn PHP / MySQL joins.

Right now I query the database twice to pull out the data i need. Below is my example:

$result = mysql_query("SELECT * FROM groups WHERE country LIKE '%$city%' ORDER BY rand() LIMIT 5") or die(mysql_error());
	while($r=mysql_fetch_array($result))
	{
        echo $r['groupID'];
			$result2 = mysql_query("SELECT * FROM images WHERE groupID='$r[groupID]' AND home='Y'") or die(mysql_error());
			while($r2 = mysql_fetch_array($result2))
			{
			echo $r2['source'];
                        }
	}

Would someone be able to help me learn MYSQL Joins with PHP / MySQL turning my example of querying the database twice into a joined statement?

Thanks

http://www.w3schools.com/sql/sql_join.asp

Thanks for the quick reply,

I'm having some trouble understanding it through words. I just thought I would learn it easier if I saw the above double MySQL query loop as a joined statement.

I think I've finally somewhat figured it out, I've been trying to learn this for months no joke.

Thanks for the link,

Maybe try something like this for your query string:

SELECT * FROM groups as g JOIN images as i on g.groupID = i.groupID WHERE g.country LIKE '%$city%' ORDER BY rand() LIMIT 5

A little test i did on my db was like this:
SELECT *, b.boxname FROM altg_menu as a JOIN altg_menubox as b on a.boxid = b.id WHERE a.id < 20