Re: Looping through a result

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

 



Rene,
This is a clarification of what I think Ignatius was talking about.

I did like this on www.deep-purple.com/tourdates:

Your database structure must look something like this for it to work:
	
ID	ITEM	CATEGORY
1	1		1
2	2		1
3	3		1
4	4		1
5	1		2
6	2		2
7	3		2
8	1		3
9	2		3
10	3		3
11	4		3

Then you do like this with PHP:

<?php
$SQL = "select * from itemsAndCategories order by CATEGORY, ITEM";
$result = mysql_query($SQL);
$lastCategory = "";
while ($row = mysql_fetch_row($result)) {
	if ($lastCategory != $row['CATEGORY']) {
		$lastCategory = $row['CATEGORY'];
		echo "<b>Category " . $row['CATEGORY'] . "</b><br />\n";
	}
	echo "Item " . $row['ITEM'] . " of category $lastCategory<br />\n";
}
?>

This should generate the list you gave as an example..

Enjoy, Mike


On Apr 20, 2004, at 09:43, Rene Schoenmakers wrote:


Hi,

I want to make the following page,

Category 1
Item 1 of category 1
Item 2 of category 1
Item 3 of category 1
Item 4 of category 1

Category 2
Item 1 of category 2
Item 2 of category 2
Item 3 of category 2

Category 3
Item 1 of category 3
Item 2 of category 3
Item 3 of category 3
Item 4 of category 3
Item 4 of category 3,

using PHP and MySQL. Looping through a result is not the problem. But
how do I use a second query while looping through a result and do I have
to use more then 1 table in the database?
Can somebody point me in the right direction?


Tia,

René

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


-- 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