Re: Re: How can I re-code?

John Taylor-Johnston wrote:

No one?

Noone knows the structure of your table. Is the table properly normalized? From the original array it seems you need at least 2 tables to properly hold the information.

I had an $array, with a list of authors and an entry number. Below is the code I used. Now I have compiled it all into a table. I don't know how to re-code these lines: foreach (array_count_values ($authors) as $author=>$count) foreach ($author_list[$author] as $ausid) -----------new code----------- $myconnection = mysql_connect($server,$user,$pass); mysql_select_db($db,$myconnection); $news = mysql_query("select ccl_id,AUS from $table ORDER by AUS");