| |
|
|
| | Приветствую всех!
такая трабла - с циклами пока не до конца разобрался.
мне нужно овт весь этот код зациклить
это голосовалка - должно выводится всё количество активных голосований, а я что то туплю.. помогите пожалуйста разобраться.
<?php
include 'config.php';
$g = $_COOKIE['valid_user'];
$query = "SELECT * FROM vote_quest WHERE activ='1'";
$ath = @mysql_query($query);
$quest = mysql_fetch_array($ath);
$id_q = $quest['id_q'];
$question1 = $quest['question'];
$query3 = "SELECT * FROM vote_results WHERE id_q='$id_q'";
$ath3 = mysql_query($query3);
$res3 = mysql_fetch_array($ath3);
$realname_id = $res3['realname_id'];
if (empty($realname_id)) {$realname_id = 0;}
if ($realname_id == $g) {echo 'Вы уже проходили это голосование';
echo '<br />';
echo $question1;
echo '<br />';
$query4 = 'SELECT * FROM vote_answer WHERE id_q="'.$id_q.'"';
$ath4 = mysql_query($query4);
while ($ans = mysql_fetch_array($ath4)){
$answer1 = $ans['answer'];
$id_a1 = $ans['id_a'];
echo "<table cellspacing=0 cellpadding=0 border=1><tr><td width=100>";
echo $answer1;
echo '</td><td width=20>';
$query6 = 'SELECT * FROM vote_results WHERE id_q="'.$id_q.'" AND id_a="'.$id_a1.'"';
$ath6 = mysql_query($query6);
$result_vote = mysql_num_rows($ath6);
echo $result_vote;
echo '</td></tr></table>';
}
}
else {
echo '<form action=result.php method=post>';
echo '<table class=1 cellspacing=o cellpading=0 width=200 bgcolor=EDF6FA><tr><td width=100% align=center><small>';
$question=$quest['question'];
echo $question;
echo '</small></td></tr></table>';
$query2 = "SELECT * FROM vote_answer WHERE id_q='$id_q'";
$ath2 = @mysql_query($query2);
echo '<table class=1 cellspacing=o cellpading=0 width=200 bgcolor=ffffff><tr><td width=100% align=left>';
WHILE ($answer = mysql_fetch_array($ath2)) {
$id_a = $answer['id_a'];
echo '<input type=radio name="answer"';
echo ' value=';
echo $id_a;
echo '><small>';
echo $answer['answer'];
echo '</small><br>';
}
echo '</td></tr></table>';
echo '<table class=1 cellspacing=o cellpading=0 width=200 bgcolor=EDF6FA><tr><td width=100% align=center>';
echo '<input type=hidden name=id_q value=';
echo $id_q;
echo '>';
echo '<input type="Submit" style="background-color:ffffff" value="Голосовать">';
echo '</td></tr></table>';
echo '</form>';}
?>
|
| |
| |
|
|
| |
|
|
| |
для: 10100100
(21.09.2006 в 12:52)
| | | А что хранится в таблицах vote_quest, vote_results и vote_answer? | |
| |
|
|
| |
|
|
| |
для: cheops
(21.09.2006 в 13:06)
| | |
CREATE TABLE `vote_quest` (
`id_q` INT NOT NULL AUTO_INCREMENT,
`question` TINYTEXT,
`activ` TINYTEXT,
PRIMARY KEY (id_q)
) TYPE = MYISAM;
CREATE TABLE `vote_answer` (
`id_a` INT NOT NULL AUTO_INCREMENT,
`id_q` TINYTEXT,
`answer` TINYTEXT,
PRIMARY KEY (id_a)
) TYPE = MYISAM;
CREATE TABLE `vote_results` (
`id_user` INT NOT NULL AUTO_INCREMENT,
`id_q` TINYTEXT,
`id_a` TINYTEXT,
`realname_id` TINYTEXT,
PRIMARY KEY (id_user)
) TYPE = MYISAM;
|
| |
| |
|
|
| |
|
|
| |
для: cheops
(21.09.2006 в 13:06)
| | | собсно вот дамп | |
| |
|
|
| |
|
|
| |
для: 10100100
(22.09.2006 в 06:46)
| | | Можно поступить следующим образом
<?php
include 'config.php';
$g = $_COOKIE['valid_user'];
$query = "SELECT * FROM vote_quest WHERE activ='1'";
$ath = @mysql_query($query);
if(mysql_num_rows($ath))
{
while($quest = mysql_fetch_array($ath))
{
$id_q = $quest['id_q'];
$question1 = $quest['question'];
$realname_id = $quest['realname_id'];
if (empty($realname_id)) {$realname_id = 0;}
if ($realname_id == $g)
{
echo 'Вы уже проходили это голосование';
echo '<br />';
echo $question1;
echo '<br />';
$query4 = 'SELECT * FROM vote_answer WHERE id_q="'.$id_q.'"';
$ath4 = mysql_query($query4);
while ($ans = mysql_fetch_array($ath4))
{
$answer1 = $ans['answer'];
$id_a1 = $ans['id_a'];
echo "<table cellspacing=0 cellpadding=0 border=1><tr><td width=100>";
echo $answer1;
echo '</td><td width=20>';
$query6 = 'SELECT * FROM vote_results WHERE id_q="'.$id_q.'" AND id_a="'.$id_a1.'"';
$ath6 = mysql_query($query6);
$result_vote = mysql_num_rows($ath6);
echo $result_vote;
echo '</td></tr></table>';
}
}
else
{
echo '<form action=result.php method=post>';
echo '<table class=1 cellspacing=o cellpading=0 width=200 bgcolor=EDF6FA><tr><td width=100% align=center><small>';
$question=$quest['question'];
echo $question;
echo '</small></td></tr></table>';
$query2 = "SELECT * FROM vote_answer WHERE id_q='$id_q'";
$ath2 = @mysql_query($query2);
echo '<table class=1 cellspacing=o cellpading=0 width=200 bgcolor=ffffff><tr><td width=100% align=left>';
WHILE ($answer = mysql_fetch_array($ath2))
{
$id_a = $answer['id_a'];
echo '<input type=radio name="answer"';
echo ' value=';
echo $id_a;
echo '><small>';
echo $answer['answer'];
echo '</small><br>';
}
echo '</td></tr></table>';
echo '<table class=1 cellspacing=o cellpading=0 width=200 bgcolor=EDF6FA><tr><td width=100% align=center>';
echo '<input type=hidden name=id_q value=';
echo $id_q;
echo '>';
echo '<input type="Submit" style="background-color:ffffff" value="Голосовать">';
echo '</td></tr></table>';
echo '</form>';
}
}
}
?>
|
| |
| |
|
|
