[mfacer]

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 Code:

<?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!