SQL query help. [Q and A] - XOOPS Web Application System

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?

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

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?

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

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.

Stats
Goal:	$100.00
Due Date:	Sep 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

SQL query help.

Re: SQL query help.

Re: SQL query help.

Re: SQL query help.

Re: SQL query help.

Login

Search

Recent Posts

Re: sbadmin5 - Bootstrap 5 Theme

Re: sbadmin5 - Bootstrap 5 Theme

Re: sbadmin5 - Bootstrap 5 Theme

Re: sbadmin5 - Bootstrap 5 Theme

sbadmin5 - Bootstrap 5 Theme

Re: XoopsFaq for 2.5.10

XoopsFaq for 2.5.10

Re: activate block by default

Re: wgFilemanager released for testing and contribution

Re: wgFilemanager released for testing and contribution

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}