in reply to Re^2: Explain SQL statement
in thread Explain SQL statement

Could I try to place the values in alphabetic order after since I can't figure it out on the SQL query.
Like to a SORT on the returned values from the "fetchrow_hashref"
Do a SORT here in one of the returned values
$comp=$pointer->{'comp_name'};

Replies are listed 'Best First'.
Re*: Explain SQL statement
by Roy Johnson (Monsignor) on May 26, 2004 at 16:25 UTC
    It is certainly possible to accumulate all the rows returned in an array (of hashes), and then sort that array by whichever hash element you like before output.

    I still think what you really want to do is to have one query that returns all the data in the desired order.


    The PerlMonk tr/// Advocate