I'm trying to build what I think is an associative array from a set of
mySQL results.
It looks like this:
//First, a mySQL results loop for a select statement return unique
occurrences of data in the field "term":
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo $row["term"];
//Then, within the loop, another search to find the number of
occurrences //of that result
$this_term[$i]=$row["term"];
$this_query = "select term from photoqueries where term = '$this_term'
order by term";
$this_result = mysql_query($this_query);
$this_num_results[$i] = mysql_num_rows($this_result);
}
//so, now I have 2 vars corresponding to each "term" value from the
table: $this_term[i], and $this_num_results[i].
That's where I get stuck! How do I stick all of my $this_term and
$this_num_results values together in an array. Once that is
accomplished, how do I then sort the array (descending) by the
$this_num_results values?
In short, what I'm trying to do is display a list of all "term" values
and the number of times that data appears in the table. If I had a
table "names" containg these values:
bob
bob
joe
sue
fred
bob
sue
jane
The display I'm trying to build would look like this:
bob 3
sue 2
jane 1
joe 1
Any help is greatly appreciated, sincerely!
Thanks!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
