пример БД (vopros):
tema \ vprs \ vrnt \ otvt
1 11? 111 | 112 | 113 113
2 22? 221 | 222 | 223 222
3 33? 331 | 332 | 333 332
кусок проги:
CODE (text):
скопировать код в буфер обмена
скопировать код в буфер обмена
- MYSQL_CONNECT($hostname,$username,$password) OR DIE("error db connection :o(");
- @mysql_select_db("$dbName") or die(":-(");
- {
- $query = mysql_query("SELECT * FROM vopros ORDER BY RAND()");
- }
- while ($data = mysql_fetch_assoc($query)) {
- if (!isset($arr[md5($data['tema'])])) $arr[md5($data['tema'])] = $data;
- }
- ?>
- <form name="sw" action='next1.php' method='post'>
- <?
- foreach ($arr as $a) {
- echo $a['tema']."<br>";
- echo $a['vprs']."<br>";
- $variants = explode("|",$a['vrnt']);
- $count=count($variants);
- for($idx=0;$idx<$count;++$idx){
- $voprosid = $a['id'];
- echo '<input type=radio name='.$voprosid.' value='.$variants[$idx].'>'.$variants[$idx];
- echo "<br>";
- }
- $otvet = $a['otvt'];
- echo $otvet."<br>";
- echo $voprosid."<br>";
- echo "<hr>";
- }
- ?>