Run a while loop on your data and pull it into an array.... Heres an example (though this pulls from a text file the idea is the same...) Hope this helps...
<?php // READING THE DATA function read_data($datafile) { $data=file($datafile); foreach ( $data as $line ) { $temp=explode(':', $line); $cp=$temp[4]; $return[$cp][]=$line; } if ( is_array($return) ) { return($return); } else { return("NULL"); } } ?> <?php // USING THE DATA $hosts=read_data('./hosts.dat'); if ( $hosts != 'NULL' ) { $count=0; foreach ( $hosts as $host ) { $temp=explode(':', $host[0]); $hostss.=str_replace("%%COMPANY%%", decode($company=$temp[4]),$template_company_begin); foreach ( $host as $hst ) { $temp=explode(':', $hst); $h_names[]=$temp[0]; $hostss.=str_replace("%%DISPLAY%%", display_host($hst, $count), $template_company_mid); $count++; } $hostss.=$template_company_end; } } else { $hosts="No Hosts In Database...<br>"; } ?> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 30, 2002 4:22 PM To: php Subject: [PHP] Pulling data into an array and sorting I need to pull data into and array from a mysql database and then sort that data according to one of the fields and then print it to the screen. Hear is an example of the data in the database username Pnumber sec2 sec3 sec4 sec5 sec6 Gary 123.345.122 YES YES NO YES YES Fred 123.345.123 YES YES NO YES YES Jone 123.345.124 YES YES YES NO YES Tom 123.345.124 YES YES NO YES YES Frank 123.345.123 YES YES NO YES YES If you will notice the Pnumber for some are the same and some are different. I what to be able to sort on this number and then when they are printed they would be printed according to this number in groups -- Best regards, rdkurth mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php