My code is;
PHP Code:
CODE
<?php
$db = @mysql_connect ("localhost","root","andy");
print "Database Connection gained";
echo '<br>';
mysql_select_db("disertation",$db);
$query = "SELECT questions.Question, questions.Option FROM questions";
$result = @mysql_query($query,$db);
while($row = @mysql_fetch_assoc($result))
{
?>
<?php
echo $row['Question'] . '<br>';
?>
<?php
switch($row['Option'])
{
case 'R':
?>
<?php
echo "<input name='" . $row['Question'] . "' type='radio' value='radiobutton'>";
echo '<br>';
?>
<?php
break;
case 'T':
?>
<?php
echo "<input type='text' name='" . $row['Question'] . "'>";
echo '<br>';
break;
}
}
?>
$db = @mysql_connect ("localhost","root","andy");
print "Database Connection gained";
echo '<br>';
mysql_select_db("disertation",$db);
$query = "SELECT questions.Question, questions.Option FROM questions";
$result = @mysql_query($query,$db);
while($row = @mysql_fetch_assoc($result))
{
?>
<?php
echo $row['Question'] . '<br>';
?>
<?php
switch($row['Option'])
{
case 'R':
?>
<?php
echo "<input name='" . $row['Question'] . "' type='radio' value='radiobutton'>";
echo '<br>';
?>
<?php
break;
case 'T':
?>
<?php
echo "<input type='text' name='" . $row['Question'] . "'>";
echo '<br>';
break;
}
}
?>
Thanks,kvarnerexpress

