Grouping Data Together

[Craig Hoffman <choffman@xxxxxxxxxx>]

Hello,
I could use some assistance here.  I'll try and explain this the best I 
can.  I'm trying to get this query to work where it pulls up all the 
rows that are associated with a  common id .  For example let say you 
have data that you want to group together.  For example:

Group 1 would look like this:

Title 1
Abstract for title 1
	- articles that belong to title 1
	- articles that belong to title 1

Then group two:
Title 2
Abstract for title 2
	- articles that belong to title 2
	- articles that belong to title 2
and so forth

Basically my script is working, it queries the correct results,  but it 
only pulls up one set of results (title 1), instead of ALL results.  I 
am including the code below, perhaps someone could take a look at it?  
I hope this makes sense?  :)
- Craig

<?php
	require ("include/db.php");

	$query = "SELECT * FROM clients, articles WHERE clients.id = 
articles.id GROUP BY co_name ORDER BY date_uploaded";
	$result = mysql_query($query, $db) or die(mysql_error());
	echo("<h3>Client List</h3>");
while ($row = mysql_fetch_array($result)) {
	
	$co_name = $row['co_name'];
	$co_logo = $row['co_logo'];
	$co_text = $row['co_text'];
	
	$corp_name = array("$co_name");
	print_r ($corp_name);
	foreach ($corp_name as $corp1_name) {
	
		$rc = "\r";	
	
			if ($co_logo = $co_logo) {
					echo ("<img src='./image/client_graphics/$co_logo' alt='$co_logo' 
width='150' height='69' class='co_name_img'>");
						}	
		echo("<p>");	
		echo ereg_replace($rc, '<br />', trim(stripslashes("<div 
class='res_header'>$corp1_name</div>")));
		echo ereg_replace($rc, '<br />', trim(stripslashes("$co_text")));

	$query = "SELECT articles.*, clients.id FROM articles, clients WHERE 
clients.id = articles.id AND co_name = '$corp1_name' GROUP BY 
article_name ORDER BY date_uploaded";
	//echo $query;
	$result = mysql_query($query, $db) or die(mysql_error());

		echo("<ul class='client_list'>");
		 while ($row = mysql_fetch_array($result)) {
			$article_name = $row['article_name'];
				echo("<li>$article_name</li>");
					}
		
		echo("</ul>");
	echo("</p>");
			}
		}
?>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php