In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> Question 1:
> How can I append strings to my authors array?
> Me thinks this doesn't work :�) ?
> $authors .= explode(";", $mydata->KW);
> I'm getting "Invalid argument supplied for foreach()"
>
> Question 2:
> Once I get this working, I want to (a) alphabetise the contents of the
> array, (b) count repititions, (c) elimintate copies, and create an array
> I can print with tow things "$author[i]\t$counter[i]", so I end up with
> something like:
See the array handling functions to resolve some of these problems.
> Adam 2
> Louis 5
> John 3
> Mary 8
>
> ------------------------------------------------------------------------
>
> $myconnection = mysql_connect($server,$user,$pass);
> mysql_select_db($db,$myconnection);
> $news = mysql_query("select KW from $table");
>
> while ($mydata = mysql_fetch_object($news))
> {
> $authors .= explode(";", $mydata->KW);
Presumably your error is occurring here; it would seem that the content
of $mydata->KW is not such that explode will create an array. There may
be cases perhaps where you do not have a series of authors names
separated by semicolons? You may have to add a test for the case where
$authors is not an array.
> }
>
> foreach ($authors as $author)
> {
> echo "$author<br>\n";
> }
> ------------------------------------------------------------------------
>
> I'm learning, slowly but surely Martin :)
I think this has already been said, but it seems there is scope to
restructure your tables in such a manner as to be able to handle a lot of
these problems with SQL from a properly designed database. Frinstance you
might have a structure that has a main table with a unique ID, the
abstract info, title, publisher etc and a separate table with author name
and ID of the main table entry.
Just at a guess, you are/have imported this information from a
bibliographic package of some sort?
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
