Never mind, finally figured it out on my own. Sorry , i think out loud sometimes!
Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > Trying to figure out how this gets done. Let me > explain first. By the way I hope this is not off > topic > as perhaps it is more towards application then core > db > . > > I have a table: > > Count[int][auto-increment], MemberID[int], > Title[varchar], TitleYear[int] > > In my organization members can have or have held > various titles. I'm trying to collect, right now, 5 > titles and the years they've held those titles. > > Extraneous - Now I'm in a precarious place, cause I > am > new to web dev and db and have had the fortunate > experience to be using an extension to dreamweaver > that makes it relatively simple. Until you have to > go > beyond what they provide in functionality / > capability. It's php / adodb. > > So I"ve looked around and found a few "methods" but > no > detail, nor have I really drilled down on how they > get > implemented. > > One method was basically a loop of sorts. Not > entirely sure but I suppose pages can keep > refreshing > 5 times. > Second, was to pass all the variables over to > another > page. It sounded like maybe this secondary page is > hidden but set up to accept an insert. The third, > which I tried, unsuccessfully, was through the use > of > after triggers. Possible I need to work on this > more. > > Anyway I wouldn't mind hearing how other people deal > with this issue. Not sure if I could set up some > SQL > statements. > > Thank you , > Stuart > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
