Your Log for the qsl card |
";
print "An Input Mistake";
print "";
print "Input your callsign.";
print "Back
";
print "";
print "";
exit;
}
//丶出条件を組み立てる
$array = explode(" ", $keyword);
$cnt = count($array);
$where = "WHERE ";
for($i=0; $i < $cnt; $i++){
$where.= "CALLSIGN LIKE '%".$array[$i]."%'";
if($i < $cnt-1){
$where .=" ".$searchSelect." ";
}
}
// クエリを送信する
$sql = "SELECT * FROM dstar ".$where;
$sql .= " ORDER BY QSONUM DESC";
$result = executeQuery($sql);
//print "test";
//結果セットの行数を取得する
$rows = mysql_num_rows($result);
//表示するデータを作成
if($rows){
while($row = mysql_fetch_array($result)) {
$tempHtml .= "
";
$tempHtml .= "| ".$row["CALLSIGN"]." | ".$row["YE_AR"]." | ".$row["DA_TE"]." | ".$row["TI_ME"]." | ".$row["REPT"]." | ".$row["REF"]." | ".$row["RIG"]." | ".$row["YrRST"]." | ";
$tempHtml .= "Print/作成 | ";
$tempHtml .= "
\n";
}
$msg = "We have met as following table. If you click [print] then my QSL card will popup.";
$msg1 = "Print a card with your internet browser print function.";
}else{
$msg = "No Data";
}
//結果保持用メモリを解放する
mysql_free_result($result);
?>
| CALLSIGN |
YEAR |
DATE |
TIME |
REPT |
REFT |
RIG |
YrRST |
QSLCARD |
|