Re: array manipulation

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

 



soln: YOU NEED A 2 WEEK HOLLIDAY at least! You need to learn to say no.
Tim-Hinnerk Heuer

http://www.ihostnz.com
Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>
- "A wide screen just makes a bad film twice as bad."

2009/4/17 PJ <af.gourmet@xxxxxxxxxxxx>

> The more I get into arrays, the less I understand.
> I have a ridiculously simple task which excapes me completely.
> I need to ouput all fields in 1 column from 1 table in two phases sorted
> alphabetically.
> So, I have the query, I have the results. But since I need to split the
> list into 2 parts, I need indexes. I cannot use the table index as it
> does not correspond to the alphabetical order of the data column. In
> order to get the index, I sort the resulting array and that now gives me
> 34 arrays each containing an array of my results. Wonderful!
> But how do I now extract the arrays from the array?
>
> Here is what I'm trying to do:
>
> $SQL = "SELECT category
>        FROM categories
>        ORDER BY category ASC
>        ";
> $category = array();
> if ( ( $results = mysql_query($SQL, $db) ) !== false ) {
>            while ( $row = mysql_fetch_assoc($results) ) {
>                $category[$row['category']] = $row;
>                }
>            sort($category);
>            //var_dump($category);
>            echo "<table >";
>            $count = mysql_num_rows($results);
>            $lastIndex = $count/2 -1; echo $lastIndex;
>            $ii = 0;
>            $cat = '';
> //print_r($category['0']['category']);
>    foreach($category as $index => $value) {
>        $ii++;
>        if ($ii != $lastIndex) {
>            $cat .= "$value, ";
>            }
>        else {
>            $cat .= " & $value<br />";
>            }
>        $catn = preg_replace("/[^a-zA-Z0-9]/", "", $cat);
>        //echo "<pre>$category</pre>";
>        echo "<tr>
>                <td><a href='../categories/", $catn, ".php'>", $cat, "</a>
>                </td>
>            </tr>" ;
>        }
> }
> echo "</table>";
>
> What should I be using in the foreach line?
> Please help!
>
> --
> unheralded genius: "A clean desk is the sign of a dull mind. "
> -------------------------------------------------------------
> Phil Jourdan --- pj@xxxxxxxxxxxxx
>   http://www.ptahhotep.com
>   http://www.chiccantine.com/andypantry.php
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux