Хелппп за един скрипт

[kokuhop]

какво трябва да променя в този скрипт



table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="275" valign="top" style="border-right:1.5px solid #cccccc;">
<form name="form1" method="post" action="<? $PHP_SELF ?>">
<table width="275" border="0" align="center" cellpadding="0" cellspacing="0">
<?
include ("lib/host_conf.php");
include ("lib/mysql.lib.php");
$objp=new db;
$objp->connect();

$query="select * from polling";
$objp->query($query);
$i=0;
$option=array();
while($row=$objp->query_fetch(1))
{
$result=$row[0];
$option[$i]=$result;
if($i==0)
{ ?>
<tr>
<td colspan="2"><? echo("$row[0]"); ?></td>
</tr>
<? }
else
{?>
<tr>
<td valign="bottom">
<input name="poll" type="radio" class="pollingcheckbox" value="<? echo($result);?>">
<? echo("$option[$i]");?>
<?
}
$i++;
}

?>
<br>
</td>
</tr>
<tr>
<td colspan="2">
<input name="Submit2" type="submit" class="newsdate" value="Vote">
</td>
</tr>
<?
$result=$_POST["poll"];
if(strlen($result)>1)
{
$query_insert="insert into poll (result) values ('$result')";
$objp->query($query_insert);
}


?>
</table>
</form></td>
<td width="275" valign="top"><?
echo "<table width=275>";

$obj=new db;
$obj->connect();
$obj1=new db;
$obj1->connect();
$vote=array();
$vote_option=array();
$perc=array();
$i=0;
$total=0;
$query="select * from polling LIMIT 1,10";
$obj->query($query);
while($row=$obj->query_fetch(1))
{
$option=$row["poll"];
$vote_option[$i]=$option;
$query_result="select COUNT(result) from poll where result='$option'";
$obj1->query($query_result);
while($row_result=$obj1->query_fetch(1))
{
$vote[$i]=$row_result[0];
}
$total=$total+$vote[$i];
$i++;
}

?>
<?
for($j=0;$j<$i;$j++)
{
$perc[$j]=(($vote[$j]/$total)*100);
?>
<?
echo "<tr><td>".($vote_option[$j]);
?>
<td><img src="picture/poll.gif" width="<? echo($perc[$j]); ?>" height="8">
<?

echo "<td>".($vote[$j]." votes")."</tr>";
}
echo "<tr><td colspan=2> <class=pollingresultred><strong>Total Votes: $total</strong></tr>";
echo "</table>";
?></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>

 

[human]

За какво е този код, какво да му променяш(защо), грешка ли има ако има каква?Не може да се пробва кода така с 20 инклуднати файла и без да имам таблицата

 

[kokuhop]

ето скрипта за базата с данни



CREATE TABLE polling (
poll varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `polling`
--

INSERT INTO polling VALUES ('What is the main objective of Democracy');
INSERT INTO polling VALUES ('Peace');
INSERT INTO polling VALUES ('Constitution');
INSERT INTO polling VALUES ('Republic');
INSERT INTO polling VALUES ('Nation');



CREATE TABLE poll (
result varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `poll`
--

INSERT INTO poll VALUES ('Constitution');
INSERT INTO poll VALUES ('Constitution');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Nation');
INSERT INTO poll VALUES ('Republic');
INSERT INTO poll VALUES ('Department of Employment');
INSERT INTO poll VALUES ('Constitution');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Constitution');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');
INSERT INTO poll VALUES ('Peace');

 

[human]

И какво му е на скрипта?Не работи ли?Ние да не сме гадатели...

 

[trevata]

Като гледам става въпрос за анкета :shock: ама немога да намера проблема... Дай и includ-натите файлове да видиме...