(через "паблик")
public String getSql(String uin, int i) {
try {
String sql;
String s[]= new String[5];
String sss="";
int m1=0;
int m2=0;
int m3=0;
int m4=0;
int m =((int)(Math.random()*(((int) srv.us.db.getLastIndex("`millioner`.`"+i+"`"))-1)))+1;
m1 =(((int)(Math.random()*4))+1);
while (m1==(m2=((int)(Math.random()*4))+1)) {}
while (m1==(m3=((int)(Math.random()*4))+1)||m2==m3) {}
m4=10-m1-m2-m3;
sql="SELECT `vopros` , `otvet` , `1` , `2` , `3` FROM `millioner`.`"
+ i
+ "` WHERE `id` = "
+ m
+" LIMIT 0 , 1;";
Log.info ("sql "+sql+" m " +m);
ResultSet rs =srv.us.db.getDb().prepareStatement(sql).executeQuery();
if(rs.next()){
sss = "Вопрос номер "
+ (i+1)
+ " на сумму "
+ psp.getIntProperty("millioner."+i)
+ " золотых\n"
+ rs.getString(1)
+ "\nВарианты ответов:\n";
s[m1] = m1 + ") " + rs.getString(2) + "\n";
s[m2] = m2 + ") " + rs.getString(3) + "\n";
s[m3] = m3 + ") " + rs.getString(4) + "\n";
s[m4] = m4 + ") " + rs.getString(5) + "\n";
sss += s[1] + s[2] + s[3] + s[4] + "У вас "
+ psp.getIntProperty("millioner.time1")
+ " секунд чтоб дать ответ.\nВводить только цифру!!!";
millioner.put(uin, new Millioner(sss, m1, i));
rs.close();
return sss;
}
rs.close();
return "*error*";
} catch (Exception ex) {
ex.printStackTrace();
return "*error*";
}
}

<?php /*
--
-- Структура таблицы `millioner`
--

CREATE TABLE `millioner` (
`id` int(11) NOT NULL auto_increment,
`question` text NOT NULL,
`answer1` varchar(255) NOT NULL,
`answer2` varchar(255) NOT NULL,
`answer3` varchar(255) NOT NULL,
`answer4` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`correct` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

*/

$host = "localhost";
$dbname = "chat";
$username = "test";
$password = "test";

$connect = mysql_connect( $host, $username, $password );
if (!$connect) {
die( Could not connect: . mysql_error());
}
$db = mysql_select_db($dbname);

$dh = "questions"; //Путь к файлам вопросов от игры миллионер
if (!is_dir($dh)){
print "Неверный путь к файлам вопроса!";
return;
}
print "Поехали...
";
$dir = opendir($dh);
while ($file = readdir($dir)){
$type =0;
switch($file){
case 100:
$type=1;
break;
case 200:
$type=2;
break;
case 300:
$type=3;
break;
case 500:
$type=4;
break;
case 1000:
$type=5;
break;
case 2000:
$type=6;
break;
case 4000:
$type=7;
break;
case 8000:
$type=8;
break;
case 16000:
$type=9;
break;
case 32000:
$type=10;
break;
case 64000:
$type=11;
break;
case 125000:
$type=12;
break;
case 250000:
$type=13;
break;
case 500000:
$type=14;
break;
case 1000000:
$type=15;
break;
default:
$type=0;
}
if ($type!=0){
$f = fopen($dh."/".$file,"r");
print "Парсим файл ".$file.", номер сложности вопроса ".$type."
";
fgets($f, 4096);
fgets($f, 4096);
while (! feof($f)){
$otvet = 0;
for ($i=0;$i<5;$i++){
$a
$i = fgets($f, 4096);
if ( $a
$i
0 == "+"){
$otvet =$i;
}
}
$sql = "INSERT INTO `millioner` VALUES ( , ".trim(substr($a
0,1))." , ".trim(substr($a
1,1))." , ".trim(substr($a
2,1))." , ".trim(substr($a
3,1))." , ".trim(substr($a
4,1))." , ".$type." , ".$otvet." )";
mysql_query($sql);
//print $sql;
unset($a);
fgets($f, 4096);
}
fclose($f);
}
}
mysql_close($connect);
print "Все...";
?>