Saving results of a multiple select

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 41530
interpreted = N
texte = Hello,I have a page where users can assign multiple related words to the word they are viewing (basically an online glossary where you link the main word to related words also in the glossary).On the page after the submit, I get the following (I have not yet tried to manipulate these results).fld_catagories - 14fld_catagories - 16fld_relatedID - 29fld_relatedID - 30fld_relatedID - 34fld_relatedID - 35fld_relatedID - 36fld_relatedID - 37fld_relatedID - 56fld_relatedID - 58fld_relatedID - 60where fld_catagories are the valid catagories for this term, and fld_relatedID are the words that I need to link this word/phrase to.The catagories will be stored in a single field in the database in the same record as the word/phrase like this - ,14,16, so I can search on ,[value],The related words will be stored in a separate, two column database with the listed word ID in column 1 and the related word ID in column 2.So in the above example, in the related.db I need to add 9 records like so:term_id related_id29 7430 7434 7435 7436 7437 7456 7458 7460 74As all of the above listed words are related to this word. So that when visitors are viewing the site they will see this word listed under the see also section for each of the above listed words.So the question is how do I work through each of the above instances of fld_relatedID in order to add these records to the database?ThanksDale-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Saving results of a multiple select (dale's stuff 2002)

Hello,I have a page where users can assign multiple related words to the word they are viewing (basically an online glossary where you link the main word to related words also in the glossary).On the page after the submit, I get the following (I have not yet tried to manipulate these results).fld_catagories - 14fld_catagories - 16fld_relatedID - 29fld_relatedID - 30fld_relatedID - 34fld_relatedID - 35fld_relatedID - 36fld_relatedID - 37fld_relatedID - 56fld_relatedID - 58fld_relatedID - 60where fld_catagories are the valid catagories for this term, and fld_relatedID are the words that I need to link this word/phrase to.The catagories will be stored in a single field in the database in the same record as the word/phrase like this - ,14,16, so I can search on ,[value],The related words will be stored in a separate, two column database with the listed word ID in column 1 and the related word ID in column 2.So in the above example, in the related.db I need to add 9 records like so:term_id related_id29 7430 7434 7435 7436 7437 7456 7458 7460 74As all of the above listed words are related to this word. So that when visitors are viewing the site they will see this word listed under the see also section for each of the above listed words.So the question is how do I work through each of the above instances of fld_relatedID in order to add these records to the database?ThanksDale-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ dale's stuff

DOWNLOAD WEBDNA NOW!

Saving results of a multiple select

2002

Top Articles:

Related Readings: