Plugin Author
YOP
(@yourownprogrammer)
Hey thadfiebich,
At the moment our plugin can not include this feature but we will try to make it available at a future release.
Regards,
YOP Team
I linked the database tables and created a query which displays what I want to see. I tried adding simple PHP to the Templates “Before Vote” box. The PHP does not show. Is there a way that I can add my own PHP/mySQL query to a template?
PS – Im trying to link WP_yop_poll_logs.user_id to wp_users.ID and they dont seem to like each other.. at the moment all I am able to get is a user id number, not the display name. Any thoughts?
here is my current query
`SELECT wp_yop_poll_votes_custom_fields.custom_field_value,
wp_yop_poll_answers.answer AS VARIANCE_answer,
wp_yop_polls.question,
wp_yop_poll_votes_custom_fields.vote_date,
wp_users.display_name
FROM wp_yop_polls INNER JOIN wp_yop_poll_answers ON wp_yop_polls.id = wp_yop_poll_answers.poll_id
INNER JOIN wp_yop_poll_custom_fields ON wp_yop_poll_custom_fields.poll_id = wp_yop_polls.id
INNER JOIN wp_yop_poll_logs ON wp_yop_poll_logs.poll_id = wp_yop_polls.id
INNER JOIN wp_yop_poll_votes_custom_fields ON wp_yop_poll_votes_custom_fields.poll_id = wp_yop_polls.id,
wp_users
WHERE wp_yop_polls.id=’2′ and
wp_yop_poll_answers.id=’5′
Plugin Author
YOP
(@yourownprogrammer)
Hi thadfiebich,
We are sorry but currently you can not add your PHP/mySQL query to a template.
Best wishes,
YOP Team