single dimensional array questions

Here is my snippet of code. It takes cardnum from the database, removes the duplicates for each individual date, and then counts how many discrete numbers there was. <!-- snippet of code starts here --> //database connect and selection here, now my sql statement: $sql = "select convert( varchar,eventime, 110) as date, cardnum from events, badge where eventtype=0 and devid=1 and events.cardnum=badge.id and badge.type = 1 and convert(varchar,eventime,110) between '$startdate' and '$enddate' group by events.eventime, events.cardnum order by convert(varchar,eventime,110), cardnum"; $query = mssql_query($sql); while ($row = mssql_fetch_assoc($query)) { $array[$row['date']][] = $row['cardnum']; } $i = 0; $j = 0; foreach ( $array as $key => $value) { echo 'date: '. $key . ', count: ' . count(array_unique($value)); echo "<br>"; $i += count(array_unique($value)); $j++; } $query = mssql_query($sql); while ($row = mssql_fetch_assoc($query)) { $array[$row['date']][] = $row['cardnum']; } $i = 0; $j = 0; foreach ( $array as $key => $value) { echo 'date: '. $key . ', count: ' . count(array_unique($value)); echo "<br>"; $i += count(array_unique($value)); $j++; } echo "total = $i<br>"; echo "average = ".round(($i/$j),1); <!-- end of code --> And now my question. What I need to do is create a single dimensional array that contains each number that count(array_unique($value)) is counting. how would I do this? I can't use the SQL query because I have to remove duplicate cardnums for each date. I was thinking of doing: $patrons = array(); //inside of the foreach have this: $patrons[] = array_unique($value); but that doesn't seem to work. because when I print_r($patrons) its creating an array of arrays of an array. here is from july 1 to july 7th. date: 07-01-2004, count: 50 date: 07-02-2004, count: 43 date: 07-03-2004, count: 33 date: 07-06-2004, count: 35 date: 07-07-2004, count: 51 Array ( [0] => Array ( [0] => 123 [1] => 204 [2] => 277 [4] => 343 [6] => 450 [7] => 552 [8] => 637 [9] => 828 [11] => 829 [12] => 1007 [13] => 1075 [14] => 1363 [15] => 1455 [17] => 1539 [18] => 1736 [19] => 1928 [23] => 1929 [25] => 2044 [26] => 2221 [29] => 2222 [34] => 2961 [36] => 2969 [37] => 3122 [39] => 3273 [42] => 3274 [46] => 3286 [47] => 3288 [51] => 3294 [52] => 3322 [53] => 3325 [54] => 3326 [56] => 3327 [57] => 3328 [59] => 3329 [60] => 3330 [61] => 3332 [62] => 3333 [63] => 3334 [64] => 3335 [65] => 3336 [66] => 3337 [68] => 3338 [69] => 3339 [70] => 3340 [71] => 3341 [72] => 3342 [73] => 3343 [74] => 3344 [76] => 3345 [77] => 3346 ) [1] => Array ( [0] => 114 [1] => 123 [2] => 277 [3] => 369 [5] => 637 [6] => 744 [7] => 829 [8] => 1264 [10] => 1702 [11] => 1738 [13] => 1911 [15] => 1928 [20] => 2221 [24] => 2222 [29] => 2593 [30] => 2961 [31] => 2969 [34] => 3037 [35] => 3273 [38] => 3274 [43] => 3322 [45] => 3336 [46] => 3338 [48] => 3347 [50] => 3348 [53] => 3349 [55] => 3350 [56] => 3351 [57] => 3352 [59] => 3353 [61] => 3354 [62] => 3355 [63] => 3356 [66] => 3357 [68] => 3358 [69] => 3359 [70] => 3360 [71] => 3361 [72] => 3362 [73] => 3363 [75] => 3364 [76] => 3365 [77] => 3366 ) [2] => Array ( [0] => 87 [2] => 344 [3] => 355 [4] => 362 [5] => 637 [7] => 744 [8] => 825 [9] => 826 [11] => 895 [13] => 1478 [15] => 1654 [17] => 2429 [18] => 2654 [20] => 2756 [21] => 2969 [22] => 3124 [23] => 3166 [24] => 3273 [27] => 3274 [29] => 3294 [31] => 3351 [32] => 3352 [34] => 3361 [36] => 3367 [37] => 3368 [39] => 3369 [40] => 3370 [42] => 3372 [43] => 3373 [44] => 3374 [45] => 3375 [46] => 3376 [47] => 3378 ) [3] => Array ( [0] => 314 [4] => 343 [7] => 637 [8] => 825 [9] => 826 [10] => 829 [11] => 1736 [13] => 1844 [15] => 2084 [17] => 2967 [18] => 2990 [19] => 2991 [21] => 3037 [23] => 3078 [24] => 3106 [25] => 3107 [28] => 3179 [31] => 3379 [34] => 3380 [36] => 3381 [38] => 3382 [40] => 3383 [41] => 3384 [42] => 3385 [44] => 3386 [45] => 3387 [46] => 3388 [47] => 3389 [48] => 3390 [49] => 3391 [51] => 3392 [53] => 3393 [54] => 3394 [55] => 3395 [56] => 3396 ) [4] => Array ( [0] => 63 [3] => 203 [4] => 286 [5] => 637 [7] => 828 [9] => 829 [10] => 1066 [12] => 1262 [13] => 1702 [14] => 1736 [16] => 1738 [17] => 1844 [19] => 1926 [20] => 2654 [23] => 2946 [24] => 2990 [26] => 2991 [29] => 3179 [31] => 3220 [33] => 3286 [35] => 3316 [38] => 3334 [39] => 3361 [41] => 3383 [43] => 3384 [44] => 3385 [45] => 3390 [46] => 3391 [48] => 3398 [49] => 3399 [50] => 3400 [53] => 3401 [55] => 3402 [59] => 3403 [63] => 3404 [65] => 3405 [71] => 3406 [72] => 3407 [73] => 3408 [74] => 3409 [75] => 3410 [76] => 3411 [77] => 3412 [79] => 3413 [81] => 3414 [82] => 3415 [83] => 3416 [84] => 3418 [85] => 3419 [86] => 3420 [87] => 3421 ) ) total = 212 average = 42.4 note that there is no july 4th and 5th because we were closed those days. what I want to do is is say after I add the first array of dates into $patrons[], say if its 10 cardnums, i'll have $patrons[0] through $patrons[9], and when I add the next day and it was 8 cardnums, it would be $patrons[10] through $patrons[17]. but instead its creating $patrons[0][0] through patrons[0][9] and next day is $patrons[1][0] through $patrons[1][7]. atleast thats what I think is happening. so how do I get it to just put all of the card nums that count(array_unique($value)) is counting into a single dimensional array? thanks