買取実績


'; for ($i = 0; $i < count($Series); $i++) { $where = ''; if ($Series[$i] != 'その他') { $where = ' AND Series = "' . $Series[$i] . '"'; $notLike[] = '%' . $Series[$i] . '%'; } else { for ($ii = 0; $ii < count($notLike); $ii++) { $where .= ' AND Series NOT LIKE "' . $notLike[$ii] . '"'; } } $sql = ' SELECT Brand, Series, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, Rank, buyDate, buyPlace, buyPrice, StaffName FROM BuyPerformance WHERE Category = "時計" AND Brand = "ブライトリング" AND buyPrice != 0 ' . $where . ' ORDER BY buyDate DESC '; if (!$res = mysql_query($sql)) { echo '実績取得失敗'; exit; } else { $output .= '

' . $Series[$i] . '

'; while ($row = mysql_fetch_array($res)) { $data = $row['buyDate'] . '
' . $row['Brand']; if ($row['Series'] != '') { $data .= ' ' . $row['Series'] . '
'; } //if ($row['ModelNumber'] != '') { $data .= ' 型番:' . $row['ModelNumber']; } if ($row['Attribute2'] != '') { $data .= ' 動力:' . $row['Attribute2']; } if ($row['Attribute1'] != '') { $data .= ' 性別:' . $row['Attribute1']; } if ($row['Attribute3'] != '') { $data .= ' ケース素材:' . $row['Attribute3']; } if ($row['Attribute4'] != '') { $data .= ' ベルト素材:' . $row['Attribute4']; } if ($row['Attribute5'] != '') { $data .= ' 文字盤色:' . $row['Attribute5']; } if ($row['Rank'] != '') { $data .= ' 商品状態:' . $row['Rank'] . '

'; } $output .= '
' . $data . '
買取価格 \\' . number_format($row['buyPrice']) . 'で成約いたしました。
(' . $row['buyPlace'] . ':' . $row['StaffName'] . ')

'; } $output .= '
'; } } ?> ブライトリング 買取実績