Hello,
I've currently got a list which is generated from a single database table:
http://openconcept.ca/rabble/newsfeeds.phtml
I can now select from this list and be presented with a more concenced list of
links into which changes can be made and summaries added:
http://openconcept.ca/rabble/superRSS.phtml?superRSS3=1259&superRSS177=1189
I can do this by ignoring the key, I can pull out the data (thanks btw, for
folks who responded to my earlier posting that brought me to this place). I've
included the code I've used here:
while(list($key,$value)=each($HTTP_GET_VARS)) {
$rdf_query = mysql_query("SELECT * FROM dbrss WHERE ID='$value' ORDER BY
Feed",$db);
while ($rdf_array = mysql_fetch_array($rdf_query)) {
echo "News Feed: " . stripslashes($rdf_array["Feed"]);
}
}
>From here though I'd like to write all of the changes to these fields to the
database. However, I'm having trouble with this, as I am no longer dealing with
simple key, value relationships, but rather with arrays of arrays.
Sending the data along via GET, gives you something like this:
http://openconcept.ca/rabble/superRSS.phtml?ID%5B%5D=1259&Title%5B%5D=The+Zapatistas+on+the+march+again2&URL%5B%5D=http%3A%2F%2Fwww.infoshop.org%2Fnews6%2Fzaps_march.html&Abstract%5B%5D=aa&ID%5B%5D=1189&Title%5B%5D=Rich+World%27s+Trade+Ministers+Discuss+New+Trade+Round+2&URL%5B%5D=http%3A%2F%2Fwww.wtowatch.org%2Fwtowatch%2Fnews%2Findex.cfm%3FID%3D2108&Abstract%5B%5D=aa&new_superRSS=new_superRSS
A real mess to convert into something you'd like to insert back into the DB
using:
$insert = mysql_query("INSERT into dbrss (Feed, Title, URL, Abstract) VALUES
('$Feed[$v]','$Title[$v]','$URL[$v]','$Abstract[$v]')",$db);
Any suggestions on how to deal with this issue?
--
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Featured Client: http://www.aboriginalrightscoalition.ca/
If a book doesn't make us better, then what on earth is it for? - Alice Walker
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
