Grouping Data Together

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux