[ben_johnson1991]

Hey.. I have a table full of links, one of the fields is called page, this is page the link is printed on.
example
link --- Page
index.php --- index
about.php --- index
edit.php ---- account
addnew.php --- forum
contact.php --- index

so i want a script that would print only
index,account,forum
as index has been duplicated.

The reason for this is so then, on each separate page, i want to use a while that will print all the links listed with that 'page'

I've been told to use an array, but i haven't managed to figure it out.


I hope i've made this clear enough..

so basically id end up with


PAGE: index
-index.php
-about.php
-contact.php

PAGE:account
-edit.php

PAGE: forum
-addnew.php


Cheers for any help guys!!!

[Jcbones]

Your question is not clear at all.

So,

You want index.php, about.php, contact.php to show up on index.

And,

edit.php to show up on account.

And,

addnew.php to show up on forum.

OR,

You only want index.php, edit.php, addnew.php to show up on any page?

OR,

is:

PAGE: index
-index.php
-about.php
-contact.php

PAGE:account
-edit.php

PAGE: forum
-addnew.php

what you want your menu to look like?

[Keith]

Nah, your question is perfectly clear.

PHP Code:

// The query
$sql = 'SELECT `link`, `page` FROM `table` ORDERBY `page`';

// The result
$res = mysql_query( $sql );

// Initialize our `$pages` array
$pages = array();

// Loop the query result
while ( $row = mysql_fetch_assoc( $res ) )
{

    // does the current `$pages` index exist?
    // example: if `$row['page']` is `index`, then $pages['index'] = array();
    if ( ! isset( $pages[ $row['page'] ] ) )
    {
        $pages[ $row['page'] ] = array();
    }

    // Add the `link` to it's corresponding `page`
    $pages[ $row['page'] ][] = $row['link'];

}

// See what we have
print_r( $pages ); 

The print_r( $pages ); should give you something like this:

Code:

Array
(
    [index] => Array
        (
            [0] => index.php
            [1] => about.php
            [2] => contact.php
        )
    [account] => Array
        (
            [0] => edit.php
        )
    [forum] => Array
        (
            [0] => addnew.php
        )
)

So now, let's build out our menu using the $pages array:

PHP Code:

echo '<ul>';

foreach ( $pages as $page => $links )
{

    echo
        '<li>',
        'PAGE: ', $page,
        '<ul>';

    foreach ( $links as $link )
    {
        echo
            '<li>',
            '<a href="./', $link, '">', $link, '</a>',
            '</li>';
    }

    echo
        '</ul>',
        '</li>';

}

echo '</ul>'; 

Which should give you something like this (only this is nested for readability):

Code:

<ul>
	<li>
		PAGE: index
		<ul>
			<li>
				<a href="./index.php">
					index.php</a>
			</li>
			<li>
				<a href="./about.php">
					about.php</a>
			</li>
			<li>
				<a href="./contact.php">
					contact.php</a>
			</li>
		</ul>
	</li>
	<li>
		PAGE: account
		<ul>
			<li>
				<a href="./edit.php">
					edit.php</a>
			</li>
		</ul>
	</li>
	<li>
		PAGE: forum
		<ul>
			<li>
				<a href="./addnew.php">
					addnew.php</a>
			</li>
		</ul>
	</li>
</ul>

[adrafa]

Nice Code Keith!!!!
Exactly what I was looking for!
How do I add more "Childs" to it?

I have the following table:

region-name-date-count
abcde-aaaaa-02/01-180
abcde-aaaaa-02/02-120
abcde-aaaaa-02/03-100
abcde-bbbbb-02/01-98
abcde-bbbbb-02/02-140
abcde-bbbbb-02/03-100
abcde-ccccc-02/01-98
abcde-ccccc-02/02-140
abcde-ccccc-02/03-100
fghijk-ddddd-02/01-180
fghijk-ddddd-02/02-120
fghijk-ddddd-02/03-100
fghijk-eeeee-02/01-98
fghijk-eeeee-02/02-140
fghijk-eeeee-02/03-100

I'm loking for the results to be:

Region: abcde
Name: aaaaa-02/01-180
-02/02-120
-02/03-100
Name: bbbbb-02/01-98
-02/02-140
-02/03-100
Name: cccccc-02/01-98
-02/02-140
-02/03-100
Region: fghijk
Name: ddddd-02/01-180
-02/02-120
-02/03-100
Name: eeeee-02/01-98
-02/02-140
-02/03-100

Your code works perfect for the region and name part, I just can't figure out how to make name a "child" of region.

I will appreciate any enlightenment on this...
Thanks!

[Keith]

This is untested as well, but it's pretty much the same thing with only an extra layer of nesting:

PHP Code:

/* - - - - - - - - - -
 * Get the data
 */

// The query
$sql = 'SELECT `region`, `name`, `date`, `count` FROM `table` ORDERBY `region`, `name`';

// The result
$res = mysql_query( $sql );

// Initialize our `$regions` array
$regions = array();

// Loop the query result
while ( $row = mysql_fetch_assoc( $res ) )
{

    // does the current `region` exist?
    // example: if `$row['region']` is `abcde`, then $regions['abcde'] = array();
    if ( ! isset( $regions[ $row['region'] ] ) )
    {
        $regions[ $row['region'] ] = array();
    }

    // do the same as above, except for the `name` key
    if ( ! isset( $regions[ $row['region'] ][ $row['name'] ] ) )
    {
        $regions[ $row['region'] ][ $row['name'] ] = array();
    }

    // add the date and count data to it's corresponding region/name
    $regions[ $row['region'] ][ $row['name'] ][] = array(
        'date'  => $row['date'],
        'count' => $row['count'],
    );

}

/* - - - - - - - - - -
 * Build the list
 */

echo '<ul>';

foreach ( $regions as $region => $names )
{

    echo
        '<li>',
        'Region: ', $region,
        '<ul>';

    foreach ( $names as $name => $datas )
    {

        echo
            '<li>',
            'Name: ', $name,
            '<ul>';

        foreach ( $datas as $data )
        {
            echo
                '<li>',
                '-', $data['date'], '-', $data['count'],
                '</li>';
        }

        echo
            '</ul>',
            '</li>';

    }

    echo
        '</ul>',
        '</li>';

}

echo '</ul>'; 

[adrafa]

Thank you very much Keith, that code really worked. I've been searching all over and others suggestions took me to nesting tables, pivoting, etc., Very confusing. Your code is clean and it does what the OP asked and what I was looking for. Again, thank you