'; $wsorgu_ana = mysql_query("SELECT id,urun_id,uye_id,miktar,siparismi,snot,onay,siparis_id,date_format(siparis_tarih,'%d/%m/%Y %H:%i:%s') as siparis_tarih FROM siparis WHERE uye_id='".$uyeid."' and siparismi='E' and siparis_id=".$siparis_id." order by Onay desc") or die(mysql_error()); while($wana= mysql_fetch_array($wsorgu_ana) ) { $wKayitVarMi = "E"; $urun_id = $wana["urun_id"]; $sid= $wana["id"]; $snot =$wana ["snot"]; $miktar= $wana["miktar"]; $onay= $wana["onay"]; $siparismi= $wana["siparismi"]; $siparis_tarih= $wana["siparis_tarih"]; $q = mysql_query("SELECT id,uadi,uozelliken,url,katid,beden FROM urunlerdb WHERE id='".$urun_id."' LIMIT 1") or die(mysql_error()); $fx = mysql_fetch_array( $q ); $uadi= $fx["uadi"]; $uozelliken= $fx["uozelliken"]; $url= $fx["url"]; $katid= $fx["katid"]; $beden= $fx["beden"]; $id= $fx["id"]; $qid= $fx["id"]; echo ' '; } echo '
Order number Product image Features Piece Special Note Order Date Status
'.$siparis_id.' Product Name = '.$uadi.'
  • Özellik = '; if (($xuozelliken==null)) { echo ' None '; } else{ echo "$xuozelliken"; } echo '
  • Beden = '.$beden.'
    • '; $wsql = " SELECT renk_id, renken FROM siparis_renk , renken WHERE siparis_renk.renk_id = renk.id and siparis_renk.siparis_id =".$sid.""; $query= mysql_query($wsql); $wRenkler = ""; while($wreq= mysql_fetch_array($query) ) { $wid = $wreq["renken"]; $wRenkler = $wRenkler . $wid ." - "; } if (strlen($wRenkler)!="0") { $wRenkler = substr($wRenkler, 0, strlen($wRenkler)-2); } echo '
  • Renkler = '.$wRenkler.'
    • '; echo '
'.$miktar.' '.$snot.' '.$siparis_tarih.' '; if ($onay==E) { echo "Approved"; } else { echo "Waiting"; } echo '
'; } else { echo ' '; } } else { echo '

My Orders

'; $wsorgu_ana = mysql_query("SELECT id,urun_id,uye_id,miktar,siparismi,snot,onay,siparis_id,date_format(siparis_tarih,'%d/%m/%Y %H:%i:%s') as siparis_tarih FROM siparis WHERE uye_id='".$uyeid."' and siparismi='E' order by Onay desc") or die(mysql_error()); while($wana= mysql_fetch_array($wsorgu_ana) ) { $urun_id = $wana["urun_id"]; $sid= $wana["id"]; $snot =$wana ["snot"]; $miktar= $wana["miktar"]; $onay= $wana["onay"]; $siparismi= $wana["siparismi"]; $siparis_tarih = $wana["siparis_tarih"]; $siparis_id = $wana["siparis_id"]; } $wsorgu_urun = mysql_query("SELECT id,siparis_id,uye_id,date_format(siparis_tarih,'%d/%m/%Y %H:%i:%s') as siparis_tarih FROM siparis_sepet WHERE uye_id='".$uyeid."' order by id desc") or die(mysql_error()); while($dondur= mysql_fetch_array($wsorgu_urun) ) { $siparis_id = $dondur["siparis_id"]; $siparis_tarih = $dondur["siparis_tarih"]; echo ' '; } } ?>