Does anyone follow what I'm trying to do?
I have a list of authors I explode from a field called AUS. I sort them
sort($authors);
The layout is agreeable. What I would like now to do is change:
array_push($authors,$singleauthor);
for
array_push($authors,$singleauthor,$mydata->id);
But how do I sort them now? These two lines permitted me to:
sort($authors);
foreach (array_count_values ($authors) as $author=>$count)
sort, count and display each occurence only once.
O'Henry, James (5) #<--- there were 5 occurences of O'Henry in my
database explode
Now what I want to do is display the id number (record number) of each
occurence of O'Henry:
O'Henry, James (5) [record 1, record 4, record, 87, record 119, record
120]
How do I re-evaluate this code, modify it to display authors one time
only,
count the number of occurences in my database
and somehow integrate $mydata->id ?
Does anyone follow what I'm trying to do?
------------------snip-----------------------------------
$myconnection = mysql_connect($server,$user,$pass);
mysql_select_db($db,$myconnection);
$news = mysql_query("select id,AUS from $table");
$authors = array();
while ($mydata = mysql_fetch_object($news))
{
$mydata->AUS = str_replace(" ;", ";", $mydata->AUS);
$mydata->AUS = str_replace("; ", ";", $mydata->AUS);
$tempauthors = explode(";", $mydata->AUS);
foreach ($tempauthors as $singleauthor)
{
if ($singleauthor <> "")
array_push($authors,$singleauthor);
}
}
sort($authors);
foreach (array_count_values ($authors) as $author=>$count)
{
echo "<a
href=\"match.php?searchenquiry=".urlencode($author)."&match=partial+match\">".$author."</a>
(".$count.")<br>\n";
}
mysql_close($myconnection);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
