Edwin
Peter Beckman wrote:
$x=0; while ($row = mysql_fetch_array($r)) { while(list($key,$val)=each($row)) { if (!empty($val)) $mydata[$x][$key] = $val; } $x++ }
Peter
On Wed, 21 May 2003, John wrote:
ok I've been racking my brain on this for a couple of days. What I need to do is after creating an array from a query some values are 0. I need to be able to "skip" both the value and the key frmprinting purposes. I have it setup in a multi-demensional array, such as: Array ( [0] => Array ( [Department] => IMAX [Occurrences] => 1 [percentage resets of completed] => 0.00 [completed] => 1 [In Progress] => 0 [Waiting for Parts] => 0 [deferred] => 0 )
[1] => Array ( [Department] => SSG [Occurrences] => 1 [percentage resets of completed] => [completed] => 0 [In Progress] => 1 [Waiting for Parts] => 0 [deferred] => 0 )
[2] => Array ( [Department] => Lobby [Occurrences] => 2 [percentage resets of completed] => 0.00 [completed] => 1 [In Progress] => 1 [Waiting for Parts] => 0 [deferred] => 0 )
[3] => Array ( [Department] => BTGallery [Occurrences] => 10 [percentage resets of completed] => 44.44 [completed] => 9 [In Progress] => 1 [Waiting for Parts] => 0 [deferred] => 0 )
[4] => Array ( [Department] => Temp [Occurrences] => 15 [percentage resets of completed] => 53.85 [completed] => 13 [In Progress] => 2 [Waiting for Parts] => 0 [deferred] => 0 )
[5] => Array ( [Department] => KidZone [Occurrences] => 16 [percentage resets of completed] => 0.00 [completed] => 11 [In Progress] => 5 [Waiting for Parts] => 0 [deferred] => 0 )
[6] => Array ( [Department] => WWC [Occurrences] => 16 [percentage resets of completed] => 35.71 [completed] => 14 [In Progress] => 1 [Waiting for Parts] => 1 [deferred] => 0 )
[7] => Array ( [Department] => BodyWatch [Occurrences] => 38 [percentage resets of completed] => 51.72 [completed] => 29 [In Progress] => 8 [Waiting for Parts] => 1 [deferred] => 0 )
[8] => Array ( [Department] => TimeZone [Occurrences] => 70 [percentage resets of completed] => 66.67 [completed] => 60 [In Progress] => 9 [Waiting for Parts] => 0 [deferred] => 1 )
[9] => Array ( [Occurrences] => 169 [percentage resets of completed] => 51.45 [Completed] => 138 [In Progress] => 28 [Waiting for Parts] => 2 [Deferred] => 1 )
) what I want it as is :
Array ( [0] => Array ( [Department] => IMAX [Occurrences] => 1 [completed] => 1 )
[1] => Array ( [Department] => SSG [Occurrences] => 1 [In Progress] => 1 )
[2] => Array ( [Department] => Lobby [Occurrences] => 2 [completed] => 1 [In Progress] => 1 )
[3] => Array ( [Department] => BTGallery [Occurrences] => 10 [percentage resets of completed] => 44.44 [completed] => 9 [In Progress] => 1 )
[4] => Array ( [Department] => Temp [Occurrences] => 15 [percentage resets of completed] => 53.85 [completed] => 13 [In Progress] => 2 )
[5] => Array ( [Department] => KidZone [Occurrences] => 16 [completed] => 11 [In Progress] => 5 )
[6] => Array ( [Department] => WWC [Occurrences] => 16 [percentage resets of completed] => 35.71 [completed] => 14 [In Progress] => 1 [Waiting for Parts] => 1 )
[7] => Array ( [Department] => BodyWatch [Occurrences] => 38 [percentage resets of completed] => 51.72 [completed] => 29 [In Progress] => 8 [Waiting for Parts] => 1 )
[8] => Array ( [Department] => TimeZone [Occurrences] => 70 [percentage resets of completed] => 66.67 [completed] => 60 [In Progress] => 9 [deferred] => 1 )
[9] => Array ( [Occurrences] => 169 [percentage resets of completed] => 51.45 [Completed] => 138 [In Progress] => 28 [Waiting for Parts] => 2 [Deferred] => 1 )
) Basically just remove the keys and values where the value is 0 or not set; any ideas would be appreciated.
John Coder
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
--------------------------------------------------------------------------- Peter Beckman Internet Guy beckman@purplecow.com http://www.purplecow.com/ ---------------------------------------------------------------------------
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
