[RESOLVED] My brain is fried, please help with this array!!!!!!

[PABobo]

ok I have my array here is the script

(typical connect information)
$get_catagories = "SELECT * from catagories";
$list_catagories = mysql_query($get_catagories)or die(mysql_error());
$catagory_list = $list_catagories;
$num_fields = mysql_num_fields($catagory_list); 
$j=0;
$x=1;
while($row=mysql_fetch_array($catagory_list)){  

for($j=0;$j<$num_fields;$j++){
$name = mysql_field_name($catagory_list, $j);
$catagories[$x][$name]=$row[$name];
 		 }$x++;
	}
$i=1;
$ii=count($catagories);
for($i=1;$i<=$ii;$i++){
$data[] = array('types' => $catagories[$i]['catagory_type'], 'names' => $catagories[$i]['catagory_name']);
}

array(24) {
  [0]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(6) "bridal"
  }
  [1]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(5) "clubs"
  }
  [2]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(7) "culture"
  }
  [3]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(6) "dining"
  }
  [4]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(6) "events"
  }
  [5]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(8) "shopping"
  }
  [6]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(4) "golf"
  }
  [7]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(6) "health"
  }
  [8]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(5) "decor"
  }
  [9]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(6) "hotels"
  }
  [10]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(4) "pets"
  }
  [11]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(7) "gallery"
  }
  [12]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(11) "real estate"
  }
  [13]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(6) "salons"
  }
  [14]=>
  array(2) {
    ["types"]=>
    string(7) "listing"
    ["names"]=>
    string(7) "tickets"
  }
  [15]=>
  array(2) {
    ["types"]=>
    string(8) "business"
    ["names"]=>
    string(17) "add your business"
  }
  [16]=>
  array(2) {
    ["types"]=>
    string(8) "business"
    ["names"]=>
    string(9) "advertise"
  }
  [17]=>
  array(2) {
    ["types"]=>
    string(8) "business"
    ["names"]=>
    string(15) "post your event"
  }
  [18]=>
  array(2) {
    ["types"]=>
    string(12) "philly_scene"
    ["names"]=>
    string(8) "about us"
  }
  [19]=>
  array(2) {
    ["types"]=>
    string(12) "philly_scene"
    ["names"]=>
    string(10) "contact us"
  }
  [20]=>
  array(2) {
    ["types"]=>
    string(12) "philly_scene"
    ["names"]=>
    string(11) "newsletters"
  }
  [21]=>
  array(2) {
    ["types"]=>
    string(12) "philly_scene"
    ["names"]=>
    string(11) "scene style"
  }
  [22]=>
  array(2) {
    ["types"]=>
    string(5) "other"
    ["names"]=>
    string(19) "atlantic city scene"
  }
  [23]=>
  array(2) {
    ["types"]=>
    string(5) "other"
    ["names"]=>
    string(19) "the main line scene"
  }
}

my array output is wonderful, nice and i like it i think.
NOW what i want to do is take each type and break it apart.
basically i have bullet {type} once types are done i want to add a blank bullet!
Can i do do this? Ok well i can't and that's why i need your help

How can i do this?

• Type1

• Type1

• Type1

• <!@@ EMPTY DUE TO NEW LISTING TYPE @@!>

• New Type2

• New Type2

• <!@@ EMPTY DUE TO NEW LISTING TYPE @@!>
  

I have tried usort (lost), array_multisort (don't thin i need it? ) 😕
someone help please, my brain hurts, i'm sure it is really easy but i like to make things difficult. I need to do this for CSS navigation. :quiet:

[bogu]

Let me show u how I would do this:

/* grab results data from DB table, order by type and name ASC */
$get_catagories = "SELECT * from catagories "; 
$get_catagories.= "ORDER BY catagory_type, catagory_name ASC"; 
$list_catagories = mysql_query($get_catagories)or die(mysql_error()); 
if (mysql_num_rows($list_catagories)) {
	while ($row=mysql_fetch_assoc($list_catagories)) {
		/**
		 * we dont make the output in here in case u need the array somewhere else
		 * creating the array based on your example:
		 * array (
		 * 		[0] => array (
		 * 					'catagory_type' => 'listing',
		 * 					'catagory_name' => 'bridal'
		 * 				)
		 * 		...
		 * 		[23] => array (
		 * 					'catagory_type' => 'other',
		 * 					'catagory_name' => 'the main line scene',
		 * 				)
		 * )
		 */
		$catagories[] = $row;
	}
}
/* print out the array so u should view how it looks like */
//echo "<pre>",print_r($catagories,1),"</pre>";

/* print out the output using <li> tags if $catagories is not empty */
if (!empty($catagories)) {
	$tmp = '';
	foreach ($catagories as $value) {
		if (!empty($tmp) and $tmp!=$value['catagory_type']) {
			echo "<li><!@@ EMPTY DUE TO NEW LISTING TYPE @@!></li>";
		}
		echo "<li>{$value['catagory_type']} => {$value['catagory_name']}</li>";
		$tmp = $value['catagory_type'];
	}
}

If u dont need that array and u need only that output, then this will do:

$get_catagories = "SELECT * from catagories "; 
$get_catagories.= "ORDER BY catagory_type, catagory_name ASC"; 
$list_catagories = mysql_query($get_catagories)or die(mysql_error()); 
if (mysql_num_rows($list_catagories)) {
	$tmp = '';
	while ($row=mysql_fetch_assoc($list_catagories)) {
		if (!empty($tmp) and $tmp!=$row['catagory_type']) {
			echo "<li><!@@ EMPTY DUE TO NEW LISTING TYPE @@!></li>";
		}
		echo "<li>{$row['catagory_type']} => {$row['catagory_name']}</li>";
		$tmp = $row['catagory_type'];
	}
}

[PABobo]

The array was just to show that i was getting the data and the fields.
This is perfection!!! Thank you Thank you Thank you!!