[PHP] database design in a survey/poll system

2010-11-17 Thread 肖晗
I plan to design a small survey/poll system similar to polldaddyhttp://polldaddy.com/ . And I have some confusion in designing the database for the multiple/single choice questions. Of course, it is possible to use one table to store the question title and another table to store the choice

Re: [PHP] database design in a survey/poll system

2010-11-17 Thread Adam Richardson
On Wed, Nov 17, 2010 at 8:42 AM, 肖晗 xiaohan2...@gmail.com wrote: I plan to design a small survey/poll system similar to polldaddyhttp://polldaddy.com/ . And I have some confusion in designing the database for the multiple/single choice questions. Of course, it is possible to use one table

Re: [PHP] database design in a survey/poll system

2010-11-17 Thread Tamara Temple
On Nov 17, 2010, at 7:42 AM, 肖晗 wrote: I plan to design a small survey/poll system similar to polldaddyhttp://polldaddy.com/ . And I have some confusion in designing the database for the multiple/ single choice questions. Of course, it is possible to use one table to store the question

[PHP] Database design

2010-02-24 Thread Angus Mann
Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate. I need some assistance with database design for a project I'm coding in

Re: [PHP] Database design

2010-02-24 Thread Paul M Foster
On Thu, Feb 25, 2010 at 03:37:38PM +1000, Angus Mann wrote: Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate. I need

Re: [PHP] database design tool

2008-02-14 Thread Dax Solomon Umaming
On Feb 12, 2008 7:46 PM, Shawn McKenzie [EMAIL PROTECTED] wrote: Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool.  I'm on Linux, so the new mysql workbench is a dud.  I used it in an alpha or prior version and it

Re: [PHP] database design tool

2008-02-13 Thread Daniel Brown
On Feb 12, 2008 7:46 PM, Shawn McKenzie [EMAIL PROTECTED] wrote: Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool. I'm on Linux, so the new mysql workbench is a dud. I used it in an alpha or prior version and it

Re: [PHP] database design tool

2008-02-13 Thread Shawn McKenzie
Thanks. I use kubuntu and have all ooo including base, but it seems very minimal. I connected via jdbc (as only other option is odbc for mysql). I can't even see how to define a key as auto increment, there is no option. I tried dbdesigner4 and it is very old and buggy on linux. I found a

[PHP] database design tool

2008-02-12 Thread Shawn McKenzie
Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool. I'm on Linux, so the new mysql workbench is a dud. I used it in an alpha or prior version and it looked promising but crashed frequently. They say a Linux version in

[PHP] Database design/relationship basics book

2001-11-16 Thread Dan McCullough
Does anyone have some recommendations for database books. This is something that I want to get better versed in as I have gotten along by visualizing the database and its relationship for small projects, but I think I need a better base and more knowledge. Recommendations can before both