import_request_variables("gp");
mysql_connect("localhost:3306","nojiriko","shinano459");
mysql_select_db("nojiriko");
mysql_query("SET NAMES ujis");
if($category){
$query="SELECT * FROM forum WHERE category like '%".$category."%' ORDER BY issue desc";
}else{
$query="SELECT * FROM forum WHERE keyword like '%".$keyword."%' ORDER BY vol desc";
}
//echo $query;//debug
//echo $keyword;//debug
//echo $category;//debug
//echo $_GET['category']."yyy";
$result=mysql_query($query);
$n=0;
while($row=mysql_fetch_array($result)){
$deta[$n]["title"]= $row["title"];
$deta[$n]["url"]= $row["url"];
$deta[$n]["issue"]= $row["issue"];
list($year[$n],$month[$n],$day[$n])=split('-',$deta[$n]["issue"]);
$n++;
}
//echo $n;//debug
echo "