https://proxy2.de/forum/posts/list/3.php JForum - http://www.jforum.net Works excellent for 2 years!

I would like to ask you for a mod or a tip: I need a table(s) of all votes (may be with IP's like identifiers).
Just it and nothing more - neither more of graphic interfaces, nor export features. I can download that data from MYSQL.

What is it for?

For example, if the question 1 is about sex - male / female
And Q2 is about smoking - yes / no

And when all answers are both 50/50

I need to know whether it is

[code]
male female total
smoking 10% 40% 50%
don't 40% 10% 50%
Total 50% 50% 100%
[/code]

or

[code]
male female total
smoking 30% 20% 50%
don't 20% 30% 50%
Total 50% 50% 100%
[/code]


So is it possible to reorganize somehow tables so that I could get the only 1 like


[code]
IP 1.male 1.female 2.yes 2.no
1.1.1.1 1 0 0 1
2.2.2.2 0 1 1 0
...
...
[/code]
(may be without IP in this case)

or each for each poll like


[code]
sex
IP male female
1.1.1.1 1 0
2.2.2.2 0 1
...
...
[/code]

[code]
smoking
IP yes no
1.1.1.1 0 1
2.2.2.2 1 0
...
...
[/code]



I can manage DataBases, but not experienced with PHP... :(

Can anyone help or just give a tip, a bit of advice?


THANKS IN ADVANCE!]]> https://proxy2.de/forum/posts/preList/7169/24245.php https://proxy2.de/forum/posts/preList/7169/24245.php GMT https://proxy2.de/forum/posts/preList/7169/24246.php https://proxy2.de/forum/posts/preList/7169/24246.php GMT