PHP - Retrieving Form Values From Multi Dimensional Array

HI ! I have a table which captures how customers came to be customer ie 'advertisement', 'friend' etc etc.

So I want to be able to show / count that N number came from referral or advertisement.

My query is simple, I select all from the Media column.

This gives me a multi-dimensional array, where each table row, becomes a new sub array. I have 3000 customers ... that's a quite a few sub arrays ! So, a sample print_r of the array looks like this:

Code: [Select]
Array
(
    [0] => Array
        (
            [media] => friend
        )

    [1] => Array
        (
            [media] => friend
        )

    [2] => Array
        (
            [media] => friend
        )

    [3] => Array
        (
            [media] => Coming Over From Old Site


I have tried using a couple of array functions such as count(array,1) and (array_count_values($media)) but they both don't count the individual values out of the sub arrays.

I'm a bit stuck - Can anyone help me ?

Many Many Thanks !!

I am having a hell of a time getting this to work. I need the keys in an array to be specific, not a sequential number or a row in my database. I need to add to the array through each loop of my while() statement. This code does it, but does not use the keys I specify, after the first entry, it starts assigning numbers to keys. Any guidance would be great.

<?php
require_once ('includes/config.php');
require_once ('includes/connect.php');

$echoarray = array();
$resultsql = mysql_query("SELECT * FROM clients")or die(mysql_error());
while($row = mysql_fetch_array($resultsql)){
    if(empty($echoarray)){
$echoarray = array(
'id' => $row['ID'],
'name' => $row['First_Name'] . " " . $row['Last_Name'],
'price' => $row['Status'],
'number' => $row['Sex'],
'address' => $row['Phys_Street'],
'company' => $row['Agency'],
'desc' => $row['Notes'],
'age' => $row['Date_Birth'],
'title' => $row['Occupation'],
'phone' => $row['Phone'],
'email' => $row['Email'],
'zip' => $row['Phys_Zip'],
'country' => $row['Phys_City']
);
}
else
{
array_push($echoarray,
$echoarray['id'] = $row['ID'],
$echoarray['name'] = $row['First_Name'] . " " . $row['Last_Name'],
$echoarray['price'] = $row['Status'],
$echoarray['number'] = $row['Sex'],
$echoarray['address'] = $row['Phys_Street'],
$echoarray['company'] = $row['Agency'],
$echoarray['desc'] = $row['Notes'],
$echoarray['age'] = $row['Date_Birth'],
$echoarray['title'] = $row['Occupation'],
$echoarray['phone'] = $row['Phone'],
$echoarray['email'] = $row['Email'],
$echoarray['zip'] = $row['Phys_Zip'],
$echoarray['country'] = $row['Phys_City']
);
    
}

Any Ideas?

I have been trying to solve this problem for a few days now and can't seem to work it out. I'm sure i'm missing some simple point..
I am using a mysql PDO fetch to return 2 fields in each row and then put them into an array of their own:
foreach ($st->fetchAll() as $row){
$subs[] = array($row['subscriber'],$row['plant']);
Some of the rows share the same $row[0], which is the 'subscriber' field. What I want to do is make up another array with each smaller array having a single, unique $row[0] and any number of added 'plant' fields following (e.g $row[1],$row[2] etc).
I've tried all sorts of ways to achieve this but am at a loss. Would someone be able to point me in the right direction ? Thanks.

I'm not entirely sure how to phrase the title, so I hope it's appropriate...

I have an array which looks like the following..
Code: [Select]
Array
(
    [contact] => Array
        (
            [0] => Array
                (
                    [name] => Someone Cool
                    [number] => 1234567890
                )

        )

    [messages] => Array
        (
            [0] => Array
                (
                    [message] => A message that was recieved
                    [date] => 1234567890
                    [type] => 1
                )

            [1] => Array
                (
                    [message] => A message which was sent
                    [date] => 1322175702616
                    [type] => 2
                )
        )
    [calls] => Array
        (
            [0] => Array
                (
                    [datetime] => 1320674980836
                    [type] => 1
                    [duration] => 7
                    [number] => 1234567890
                )

            [1] => Array
                (
                    [datetime] => 1320675327541
                    [type] => 2
                    [duration] => 638
                    [number] => 1234567890
                )
       )

)


[messages] can have anywhere between 40 and 3000 children
[calls] can have anywhere from 0 to 200ish children
** These are generals, but realistically, either can have any number.

What I'm trying to do is dump all messages and calls.

The catch is this: When dumping a call, a check needs to be run against datestamps and only dump the next call coming out where the datestamp of the call is NEWER than the LAST message dumped, AND OLDER than the message that is to be dump in this cycle of the loop.  What I have so far is the following...
Code: [Select]
foreach($vardump['messages'] as $message) {

// So we have a reference point for the first call we're going to dump
if(!is_numeric($last_message_stamp)) { $last_message_stamp = $message['date']; }

            if( trim($vardump['calls'][$calls_counter]['datetime']) > trim($last_message_stamp) &&
trim($vardump['calls'][$calls_counter]['datetime']) < trim($message['date'])) {

// Dump the calls row!
echo("
<div class=\"chatbubble-call\">
            <div class=\"chatbubble-person\">".$vardump['contact'][0]['name']."</div>
            <p>".$vardump['calls'][$calls_counter]['number']."</p>
<p>".date("h:i:s", $vardump['calls'][$calls_counter]['number'])."</p>
            <div class=\"chatbubble-datetime\">".date("l, j F, Y -- h:i:s", $vardump['calls'][$calls_counter]['datetime'] / 1000)."</div>
        </div>
");

// Increase our calls index
$calls_counter++;


}


// Begin dumping Texts out :D
// Let's see which style type we're dumping out...
if($message['type'] == 2) { // Message Sent

echo("
<div class=\"chatbubble-sent\">
<div class=\"chatbubble-person\">Pat Litke</div>
<p>".$message['message']."</p>
<div class=\"chatbubble-datetime\">".date("l, j F, Y -- h:i:s", $message['date'] / 1000)."</div>
</div>
");


} else { // Message Recieved

echo("
<div class=\"chatbubble-recieved\">
<div class=\"chatbubble-person\">".$vardump['contact'][0]['name']."</div>
<p>".$message['message']."</p>
<div class=\"chatbubble-datetime\">".date("l, j F, Y -- h:i:s", $message['date'] / 1000)."</div>
</div>
");

}

// Reset our $last_messge_stamp variable
$last_message_stamp = $message['date'];




}

I should also add that I am using the following queries to pull this date out of my database...
Code: [Select]
$sql_get_messages = "SELECT * FROM messages
WHERE thread_number LIKE '%$the_thread%'
ORDER BY epoch_date ASC";

$sql_get_calls = "SELECT * FROM calls
WHERE number LIKE '%$the_thread%'
ORDER BY datetime ASC";

$sql_get_contact = "SELECT * FROM contacts
WHERE number LIKE '%$the_thread%'
LIMIT 1";

But, I feel that this is horribly inefficient, and it doesn't work right... I only ever get a single call dumped.  What am I doing wrong?

I have an array which will be below. The array is being built from an XML file, the problem is I need to extrapolate data from it.   I am having trouble with looping through the array properly.   The output should be something like this:   Beth's state is 0   (Where Beth's is the name and 0 is the state) Clint's state is 0

Array
(
    [0] => Array
        (
            [did] => 216616014153767704
            [known] => 1
            [lock] => 0
            [state] => 0
            [level] => 100
            [node] => 30
            [port] => 0
            [nodetype] => 16386
            [name] => Beth's
            [desc] => LED
            [colorid] => 1
            [type] => multilevel
            [rangemin] => 0
            [rangemax] => 99
            [power] => 0
            [poweravg] => 0
            [energy] => 0
            [score] => 0
            [productid] => 1
            [prodbrand] => TCP
            [prodmodel] => LED A19 11W
            [prodtype] => LED
            [prodtypeid] => 78
            [classid] => 2
            [class] => 
            [subclassid] => 1
            [subclass] => 
            [other] => 
        )

    [1] => Array
        (
            [did] => 216616014154116936
            [known] => 1
            [lock] => 0
            [state] => 0
            [level] => 100
            [node] => 30
            [port] => 0
            [nodetype] => 16386
            [name] => Clint's
            [desc] => LED
            [colorid] => 1
            [type] => multilevel
            [rangemin] => 0
            [rangemax] => 99
            [power] => 0
            [poweravg] => 0
            [energy] => 0
            [score] => 0
            [productid] => 1
            [prodbrand] => TCP
            [prodmodel] => LED A19 11W
            [prodtype] => LED
            [prodtypeid] => 78
            [classid] => 2
            [class] => 
            [subclassid] => 1
            [subclass] => 
            [other] => 
        )

)