I create a new page called "customPoll.php" which I include on my website homepage. It basically gets which ever poll I want to include on the page. Its not that efficient, in that if I want to display another poll, I have to edit the file to do it...
... but it does the job!!
check out www.yu-gi-oh-online.co.uk to see it in action!!
<?php
//get the poll from the DB
$host = 'x';
$username = 'x';
$password = 'x';
$db = 'x';
$conn_type = 'mysql_pconnect';
$connection = mysql_connect( $host, $username, $password ) or die( "Connection Error" );
mysql_select_db($db);
$query = "SELECT * FROM poll WHERE pollid='2'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
//split up the options, and the votes
$splitoptions=explode("|||", $row[options]);
$splitvotes=explode("|||",$row[votes]);
//now lets output the poll
?>
<link href="../images/style.css" rel="stylesheet" type="text/css">
<table width="250" border="0" cellspacing="0" cellpadding="5" class="links_table">
<tr>
<td height="30" colspan="2" class="links_top"><div align="center"><strong><font size="2">Current
Poll</font></strong></div></td>
</tr>
<tr>
<td colspan="2" height="35"><?php echo $row['question']; ?></td>
</tr>
<?php
//output each option and number of votes
for ($x=0;$x<=sizeof($splitoptions)-1;$x++)
{
echo "<TR>";
echo "<TD align='right'><strong>" . $splitoptions[$x] . ": </strong></TD>";
//get the % of votes (used for the bar image)
$size = round($splitvotes[$x] / $row['voters'] * 100);
echo "<TD align='left' width='100'><img src='../images/bar.gif' width='" . $size . "' height='5' alt='Number of Votes: " . $splitvotes[$x] . "'></TD>";
echo "</TR>";
}
?>
<tr>
<td height="52" colspan="2"><div align="center"><a href="http://www.yu-gi-oh-online.co.uk/forum/showthread.php?threadid=29">Click
here to place your vote!</a></div></td>
</tr>
</table>
hope people find it useful!