Re: Need a PHP clue

Jonathan, I have such a thing on one of my sites (see http://www.goofiness.com/personality/). The admin side, for adding, updating and deleting questions is setup this way: I have a table in my database for the questions/answers. I chose to not over-normalize the tables, because of the simplicity of the setup. So, my MySQL table looks like this: PersonalityID Question AnswerA AnswerB AnswerC AnswerD AnswerE AddedDate Those datatypes are Int, 6 mediumtext and one Date. If a particular question has only 3 answers, then AnswerD and AnswerE are left blank. When my PHP front end pulls up a test, it checks if($AnswerE!='') { print $AnswerE; } etc. The admin form to add and update has 6 textareas, one for the question and each answer. There is a hidden field for the PersonalityID. When updating, I use a query like this: update Personality set Question = '$Question', AnswerA = '$AnswerA' ...blah,blah... where PersonalityID = $PersonalityID When I first set out to do this, 3 1/2 years ago, I had this uber normalized db that stored questions in one table and answers in another. This was too complex, though, for the simple and straightforward needs I had. Hope that helps, Hans On Thu, 10 Aug 2000, Jonathan Chum wrote: > I really need some help with this one guys. > > I am trying to create an edit function for my poll script. Modifying > questions is not a problem, only when it comes to editing, updating, > and deleting the answers possible for the poll. I'd like to do it in > one step. > > My table is organized with a unique id for each answer to the poll, a > pollid column which is uses to see which answer will be shown for what > poll, and the answer it self. > > Each poll has a max of 5 questions, so 5 text boxes are created. In > each text box, the answer is prefilled. Now here's the problem. . . I > cannot figure out how to pass the info to PHP so that it knows where > to find the row and do either an update, insert, or delete. > > I was trying to have the name tag of each text box be the unique id > and the value will be an answer to the poll. Problem is that I cannot > figure how with PHP to know the variable name which is passed and > hence, I cannot do the tasks needed. > > Basically I need to pass some how, an identifier for each of the 5 > answer text box so I can perform a query using WHERE. > > Any ideas? Thanks. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > Hans Anderson ~ me@hansanderson.com PO Box 426, Missoula, MT 59806 | PHP, Search Engines, SQL (800)397-9116 / (406)549-6524 | Databases, Flash Multimedia, http://www.hansanderson.com | Killer Audio Production, http://www.goofiness.com | Minty Fresh Breath.