How can I join these two queries?

facarroll

I have two queries that work fine. I cannot work out how to join them so that I can echo all of the results combined into the same array. I've unsuccessfully tried all of the JOIN methods, and also tried array_merge (although I suspect that there may be processing disadvantages if I use the latter). I've posted the two SELECT statements below, with their respective while statements.
managerId is the only column name common to the two tables, but see the reference to $egroup in the following paragraph.
$userId, $managerId and $egroup are session variables. When the variable $egroup=1 it equates to the name of one of six other columns in the topics table.

<?php
$query1 = mysql_query("SELECT url_big, url_small, title, comment 
					  FROM topics
					  WHERE managerId = $managerId AND $egroup = 1 ORDER BY title ASC"); 

while ($row1 = mysql_fetch_array($query1))

{
echo "<a href='../../wood/wood_tool_images/{$row1['url_big']}' target='_blank'><img src='../../wood/wood_tool_images/{$row1['url_small']}' /><br />\n"; 
echo "{$row1['title']} <br />\n"; 
echo "<a href='../equipment/{$row1['title']} Safety Quiz/{$row1['title']} Safety Quiz.php'>Take This Quiz</a><br />\n";
}
?>

and

<?php
$query2 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' ORDER BY quizTitle, userDate ASC"); //query OK

while ($row2 = mysql_fetch_array($query2))

{
echo "{$row2['userScore']} <br />\n";
echo "{$row2['passState']} <br />\n";
echo "{$row2['userDate']} <br />\n";
echo "blah, blah <br />\n";
	}
?>

The following code will show what I am trying to do, so far unsuccessfully.

<?php 
$query1 = mysql_query("SELECT DISTINCT topics.comment, topics.url_big, topics.url_small, topics.title, topics.pdf
					  FROM topics
					  INNER JOIN quiz
					  ON (topics.managerId = quiz.managerId)
					  WHERE topics.$egroup = 1 
					  AND quiz.userId = '$userId'
					  AND quiz.passState = '$passState'
					  ORDER BY topics.title ASC
					  ");

while ($row1 = mysql_fetch_array($query1))
{
 echo "<img src = '{$row1['url_small']}' /><br />\n"; 
 echo "{$row1['title']} <br />\n"; 
 echo "<a href='{$row1['title']} .php'>Click this link</a><br />\n"; 
 echo "<img src='filename1.jpg' /><br />\n";
 echo "{$row1['comment']} <br />\n";
 	if ("{$row1['quiz.passState']}" == 1 ) 
	{echo "<img src='filename2.png' /><br />\n";} 
	 else {echo "blah, blah";} 
}
?>

Bonesnap

Okay, so these are your two queries:

SELECT url_big, url_small, title, comment
FROM topics
WHERE managerId = $managerId
AND $egroup = 1
ORDER BY title;

SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, userDate
FROM quiz
WHERE managerId = $managerId
AND userId = $userId
ORDER BY quizTitle, userDate;

Laserlight will kill me for suggesting this, but you could try a natural join, since you said the tables only have one column name in common:

SELECT DISTINCT url_big, url_small, title, comment, quizTitle, userId, passState, userScore, totalScore, userDate
FROM topics
NATURAL JOIN quiz
WHERE managerId = [some value]
//add additional WHERE clauses if needed
ORDER BY title;

If you prefer to avoid using natural joins, then modify the above query to:

SELECT DISTINCT url_big, url_small, title, comment, quizTitle, userId, passState, userScore, totalScore, userDate
FROM topics
JOIN quiz ON topics.managerId = quiz.managerId
WHERE managerId = [some value]
//add additional WHERE clauses if needed
ORDER BY title;

To be honest I am confused about your explanation regarding the $egroup variable. Could you perhaps explain exactly what you're trying to accomplish with the query(ies)?

facarroll

Thanks for the reply.
In explanation, table topics contains the following columns that are relevant to the query. managerId, comment, title, url_big, url_small.
Table quiz contains columns managerId, userId, passState, userDate.
topics.managerId and quiz.managerId contain matching data.
quiz.userId matches the session variable $userId.
quiz.passState is a true/false datatype which returns 1 or 0.
quiz.userDate is a date field I would like to use to select the most recent entry to the database, but this may be complicated by the fact that some rows have been deleted.
There is one more relevant session variable. The topics table contains six columns names egroup1 ..... egroup6 which represent generic names for up to six student groups, such as "grade 1", "grade 2"... "grade 6". The fields in these columns have a true/false value represented by 1 or 2. The purpose of these columns is to allocate quizzes (represented by the data in title) to any or all of the six groups.
Now when a user logs on a variable named $egroup is created, and this represents the individualised class name that is allocated by the manager. The variable $egroup can have any of six values, being egroup1 ... egroup6 which is the column name of thesix columns in the topics table.

The purpose of the whole thing is to be able to echo the combined array into an HTML table which will display rows showing a machine image url_small a quiz title title, a comment about the quiz which converts to a link to the online quiz comment, filename1.png, filename2.png, filename3.png which display a check, a cross or a query icon, representing whether the quiz has been attempted or not and the result. The userDate is meant to display the latest relevant icon.

If it helps, you can see the page ( without the filename(s).png) at http://www.safetytestingonline.com/demonstration/admin_login/stud_do_quiz.php

You will need to log in but that information is provided on the login form.

I hope you can follow this. If you think you can help, I'd really appreciate it.