Re: Polls?

Leif, off the wall...what if you have a table for question, identified with an unique ID, and another where you store the results? BTW: how are the questions? Yes/No, or multiple choices, or combination of these two styles? On Fri, 8 Nov 2002, Leif K-Brooks wrote: > The problem is, I need to make a page that shows all of the polls, and > one query per poll would kill the server. > > Peter Beckman wrote: > > >Use the dual table questions and answers suggestion before. > > > >Then just use a loop: > > > >$question = mysql_query("select * from questions where id={$this_question}"); > >while ($r = mysql_fetch_array($question)) { > > $answers = mysql_query("select * from answers where qid={$r[id]}"); > > while ($s = mysql_fetch_array($answers)) { > > print "<question input and labels>"; > > } > >} > > > >On Fri, 8 Nov 2002, Leif K-Brooks wrote: > > > > > > > >>I'm working on a polling system, and I'm having a bit of a problem. I'm > >>not sure how to store the questions. Storing them in a seperate table > >>would require a query for each poll displayed - not good. I've also > >>thought of storing them as a serialized array. Any thoughts on this? > >> > >>-- > >>The above message is encrypted with double rot13 encoding. Any unauthorized attempt to > >>decrypt it will be prosecuted to the full extent of the law. > >> > >> > >> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, visit: http://www.php.net/unsub.php > >> > >> > >> > > > >--------------------------------------------------------------------------- > >Peter Beckman Systems Engineer, Fairfax Cable Access Corporation > >beckman@purplecow.com ܼZ
Ì] > >>×›ÿ!%̤©http://www.purplecow.com/ > >--------------------------------------------------------------------------- > > > > > > > > > > -- > The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt > it will be prosecuted to the full extent of the law. > > >