XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / SQL query help.
Register
1
animas
SQL query help.

  • 2005/5/21 16:07

  • animas

  • Quite a regular

  • Posts: 206

  • Since: 2005/1/30


I am talking about xoopspoll.

Does it save which user votes which answers for a particular poll?

If it does, how do I find those users by query(using phpmyadmin)?
Then how do I email only to those users?
2
christian
Re: SQL query help.

  • 2005/5/21 16:33

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Quote:
Does it save which user votes which answers for a particular poll?


SELECT log.user_id, u.name, u.email, o.option_text
FROM (xoops_xoopspoll_log log LEFT JOIN xoops_xoopspoll_option  o ON (log.poll_id = o.poll_id) 
AND (log.option_id = o.option_id)) 
LEFT JOIN xoops_users u ON log.user_id = u.uid
WHERE log.poll_id=2;


Best regards
3
animas
Re: SQL query help.

  • 2005/5/21 20:31

  • animas

  • Quite a regular

  • Posts: 206

  • Since: 2005/1/30


Thanks.

If poll id is "1" and the correct answer is 3rd one among 5 which things in the code should be updated?
4
christian
Re: SQL query help.

  • 2005/5/21 20:40

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


You add just at end

for to have the good answers

and log.option_id=3

Also

and log.option_id <> 3
5
animas
Re: SQL query help.

  • 2005/5/21 20:45

  • animas

  • Quite a regular

  • Posts: 206

  • Since: 2005/1/30


What a fast reply!

Many thanks.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

309 user(s) are online (125 user(s) are browsing Support Forums)

Members: 0

Guests: 309

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits