0){ $sql = "SELECT * FROM TM_Customers WHERE CCode=$c_code"; $class_sql->sql_query($sql); if($row = $class_sql->sql_fetch()){ // $user_id = $row["UserID"]; $mail = $row["Mail"]; $password = $row["Password"]; $regist_date = $row["RegistDate"]; $name_kanji = $row["NameKanji"]; $name_kana = $row["NameKana"]; $post_no = $row["PostNo"]; $pref = $row["AddrPref"]; $addr1 = $row["Addr1"]; $addr2 = $row["Addr2"]; $tel1 = $row["Tel1"]; $tel2 = $row["Tel2"]; } } require('headder_n.php'); ?>
" method="POST">
ご注文一覧
sql_query($sql); while($row = $class_sql->sql_fetch()){ $seq_no = $row['SeqNo']; $order_no = $row['OrderNo']; $order_date = $row['OrderDate']; if($old_order_no != $order_no){ //1注文の先頭 $old_order_no = $order_no; $c_code = $row['CCode']; $name_kanji = $row['NameKanji']; $name_kana = $row['NameKana']; $addr = $row['PostNo'] . " " . $row['AddrPref'] . $row['Addr1'] . $row['Addr2']; $addr2 = $row['PostNo2'] . " " . $row['AddrPref2'] . $row['Addr12'] . $row['Addr22']; $tel1 = "TEL1:" . $row['Tel1']; $tel2 = "TEL2:" . $row['Tel2']; $tel12 = "TEL1:" . $row['Tel12']; $tel22 = "TEL2:" . $row['Tel22']; /* echo << EOT; */ // /// // // // } $item_code = $row['ItemCode']; $item_name = $row['ItemName']; $item_color = $row['Color']; if($item_color != "-"){ $item_name .= " 色:" . $item_color; } $price_one_s = get_num_string_3sp($row['OnePrice']); $price_all_s = get_num_string_3sp($row['Price']); $no = $row['No']; echo << EOT; $line_no += 1; } ?>
$order_date$name_kanji住所:$addr1$tel1$tel2 顧客番号:$c_code
注番:$order_no$name_kana発送先:$addr2$tel12$tel22
$order_no : $row['CCode']
品番:$item_code $item_name 単価:$price_one_s 数量:$no 金額:$price_all_s
ご注文履歴はございません。
EOT; } ?>