ola sou novo aqui, bom to com problema que chato pra mim, procurei esse problema aqui e achei como resolver, pessoal falou que o numero de campos tem que ser igual ao numero de valores, porem nao consegui, eu nao entendo de php e acho que talvez algum outro lugar tambem esteja errado, se alguem puder me ajudar e da uma olhada no codigo e me informar os erros eu agradeceria... > 0) { $str=substr($objcode->auction_code,1); $s=explode('0',$str); for($i=0;$i<2;$i++) { if($s[$i]=="") { $temp.="0"; } } $auccode="S".$temp.($str+1); } else { $auccode = "S0001"; } if($changesval=="1" && $auc_status=="2") { $auc_status = 1; } $qryins = "Insert into auction (categoryID,productID,auc_start_price,auc_fixed_price,auc_final_price,auc_start_date,auc_end_date,auc_start_time,auc_end_time,auc_status,auc_type,fixedpriceauction,pennyauction,nailbiterauction,offauction,nightauction,openauction,time_duration,auc_recurr,total_time,shipping_id,auction_code,future_tstamp,auction_min_price,min_win_price) values('$categoryID','$productID',$auc_start_price,$auc_fixed_price,'','$auc_start_date','$auc_end_date','$auc_start_time','$auc_end_time','$auc_status','$auc_type','$fpa','$pa','$nba','$off','$na','$oa','$duration','$auc_recu','$auc_due_time','$shippingmethod','$auccode','$futuretstamp','$minimumaucprice','".$minwinprice."')"; mysql_query($qryins) or die(mysql_error()); $auctionID = mysql_insert_id(); if($auc_status==2) { $qry = "Insert into auc_due_table (auction_id,auc_due_time,auc_due_price) values($auctionID,'$auc_due_time',$auc_start_price)"; mysql_query($qry) or die(mysql_error()); } header("location: message.php?msg=14"); exit; } if($_REQUEST["editauction"] && $_REQUEST["edit_auction"]) { $futuretstamp = mktime($aucstarthour,$aucstartmin,$aucstartsec,$auc_start_date_ex[1],$auc_start_date_ex[0],$auc_start_date_ex[2]); if($changesval=="1") { $auc_status = 1; } if($_REQUEST["aucstatus"]=="4") { $auc_status = 4; } $editid = $_REQUEST["edit_auction"]; $userid = $_REQUEST["userid"]; if($_REQUEST["auc_back_status"]=="3" and $userid==3) { //delete record from won_auctions and bid_account and $delwonentry = "delete from won_auctions where userid='3' and auction_id='".$editid."'"; mysql_query($delwonentry) or die(mysql_error()); $delbidaccentry = "delete from bid_account where user_id='3' and auction_id='".$editid."'"; mysql_query($delbidaccentry) or die(mysql_error()); $delaucdueentry = "delete from auc_due_table where auction_id='".$editid."'"; mysql_query($delaucdueentry) or die(mysql_error()); //end $auc_due_time = getHours($aucstartdate,$aucenddate,$aucstarthour,$aucendhour,$aucstartmin,$aucendmin,$aucstartsec,$aucendsec); if($auc_status==2) { $q = "select * from auc_due_table where auction_id=$editid"; $r = mysql_query($q); $to = mysql_num_rows($r); if($to>0) { $qry = "update auc_due_table set auc_due_time=$auc_due_time, auc_due_price=$auc_start_price where auction_id=$editid"; } else { $qry = "Insert into auc_due_table(auction_id,auc_due_time,auc_due_price) values($editid,'$auc_due_time',$auc_start_price)"; } mysql_query($qry) or die(mysql_error()); } $qryupd = "update auction set categoryID='$categoryID', productID='$productID',auc_start_price='$auc_start_price',auc_start_date='$auc_start_date',auc_end_date='$auc_end_date', auc_start_time='$auc_start_time', auc_end_time='$auc_end_time', auc_status='$auc_status', fixedpriceauction='$fpa',pennyauction='$pa',nailbiterauction='$nba',offauction='$off',nightauction='$na',openauction='$oa',time_duration='$duration', auc_recurr='$auc_recu',auc_fixed_price=$auc_fixed_price,total_time='$auc_due_time',buy_user='',auc_final_end_date='0000-00-00 00:00:00',auc_final_price='0',shipping_id='$shippingmethod',future_tstamp='$futuretstamp',auction_min_price='$minimumaucprice',min_win_price='$minwinprice' where auctionID='$editid'"; mysql_query($qryupd) or die(mysql_error()); header("location: message.php?msg=15"); exit; } else { if($_REQUEST["auc_back_status"]!=2) { $q = "select * from auc_due_table where auction_id=$editid"; $r = mysql_query($q); $to = mysql_num_rows($r); if($auc_status==2) { $auc_due_time = getHours($aucstartdate,$aucenddate,$aucstarthour,$aucendhour,$aucstartmin,$aucendmin,$aucstartsec,$aucendsec); if($to>0) { $qry = "update auc_due_table set auc_due_time=$auc_due_time, auc_due_price=$auc_start_price where auction_id=$editid"; } else { $qry = "Insert into auc_due_table (auction_id,auc_due_time,auc_due_price) values($editid,'$auc_due_time',$auc_start_price)"; } mysql_query($qry) or die(mysql_error()); } } $qryupd = "update auction set categoryID='$categoryID', productID='$productID', auc_start_price='$auc_start_price',auc_start_date='$auc_start_date',auc_end_date='$auc_end_date', auc_start_time='$auc_start_time', auc_end_time='$auc_end_time', auc_status='$auc_status', fixedpriceauction='$fpa',pennyauction='$pa',nailbiterauction='$nba',offauction='$off',nightauction='$na',openauction='$oa',time_duration='$duration', auc_recurr='$auc_recu',auc_fixed_price=$auc_fixed_price,total_time='$auc_due_time', shipping_id='$shippingmethod',future_tstamp='$futuretstamp',auction_min_price='$minimumaucprice',min_win_price='$minwinprice' where auctionID='$editid'"; mysql_query($qryupd) or die(mysql_error()); header("location: message.php?msg=15"); exit; } } if($_REQUEST["delete_auction"]) { $delid = $_REQUEST["delete_auction"]; $qryseld = "select auc_status from auction where auctionID=".$delid; $resseld = mysql_query($qryseld); $totalrow = mysql_affected_rows(); $del = mysql_fetch_object($resseld); if($del->auc_status==2) { header("location: message.php?msg=16"); exit; } $qrydel = "delete from auction where auctionID='$delid'"; mysql_query($qrydel) or dir(mysql_error()); header("location: message.php?msg=13"); } if($_REQUEST["auction_edit"]!="" or $_REQUEST["auction_delete"]!="" or $_REQUEST["auction_clone"]) { if($_REQUEST["auction_edit"]!=""){$aid=$_REQUEST["auction_edit"];} if($_REQUEST["auction_delete"]!=""){$aid=$_REQUEST["auction_delete"];} if($_REQUEST["auction_clone"]!=""){$aid=$_REQUEST["auction_clone"];} $qrys = "select * from auction a left join products p on a.productID=p.productID where auctionID=".$aid; $ress = mysql_query($qrys); $total = mysql_affected_rows(); $rows = mysql_fetch_object($ress); if($total>0) { $category = $rows->categoryID; $product = $rows->productID; $pprice = $rows->price; $aucstartprice = $rows->auc_start_price; $aucstartdate = $rows->auc_start_date; //$aucstartyear = substr($aucstartdate,0,4); //$aucstartmonth = substr($aucstartdate,5,2); //$aucstartdate = substr($aucstartdate,8,2); $aucenddate = $rows->auc_end_date; //$aucendyear = substr($aucenddate,0,4); //$aucendmonth = substr($aucenddate,5,2); //$aucenddate = substr($aucenddate,8,2); $aucstarttime = $rows->auc_start_time; $aucsthours = substr($aucstarttime,0,2); $aucstmin = substr($aucstarttime,3,2); $aucstsec = substr($aucstarttime,6,2); $aucendtime = $rows->auc_end_time; $aucendhours = substr($aucendtime,0,2); $aucendmin = substr($aucendtime,3,2); $aucendsec = substr($aucendtime,6,2); $aucstatus = $rows->auc_status; $auctype = $rows->auc_type; $aucrecu = $rows->auc_recurr; $aucfixedprice = $rows->auc_fixed_price; $userid = $rows->buy_user; $shippingchargeid = $rows->shipping_id; $auccode = $rows->auction_code; } } ?> ``` ```

Editar Leilão Excluir Leilão Adicionar Leilão

* Campos Obrigatorios

auction_min_price>0) { } else { ?> style="display: none;" > auction_min_price>0) { } else { ?> style="display: none;" >

(Atenção: Este leilão está aberto, então você não pode modificá-lo no momento.)

* Categoria :

* Produto :

* Valor de mercado do Produto:

Tipo de Leilão :

fixedpriceauction=="1"?"checked":""?> type="checkbox" name="fpa" value="1" onclick="EnableDisableFixAuc(this);"> Preço Fixo	pennyauction=="1"?"checked":""?> type="checkbox" name="pa" value="1"> 1 Centavo	nailbiterauction=="1"?"checked":""?> type="checkbox" name="nba" value="1"> Pregão
offauction=="1"?"checked":""?> type="checkbox" name="off" value="1"> 100% off	nightauction=="1"?"checked":""?> type="checkbox" name="na" value="1"> Leilão Noturno	openauction=="1"?"checked":""?> type="checkbox" name="oa" value="1"> Leilão Aberto

* Preço inicial:

* Preço Fixo:

(Obrigatória: Se o tipo de leilão selecionado for preço fixo)

Data :

" />

à " />

Horário :

: : "> : : "> : : "> : "> "> To : "> : : "> : : "> : : "> : "> "> (24 horas)

Iniciar Imediatamente

Status :

(Nota: Se o status está ativo e data de início é a data do leilão futuro então será considerado como leilão futuro.
Se o status estiver pendente entao o leilão não será salvo para venda, altere o status par ativo para coloca-lo à venda.)

Duração :

Forma de Entrega:

auction_min_price>0) { echo "checked"; } ?> type="checkbox" value="minimum" id="minimum_auction" name="minimum_auction" onclick="SetAuctinoMinimum();" /> Definir Preço Minimo.

Preço Minimo :

" />
(Nota: Leilão não fechara enqnto valor dos lances não chegar ao preço minimo.
Calculo para preço minimo:
Definir preço do leilão: preço fixo + valor dos bids dados pelos usuario
100% Off: Valor total real dos bids feitos pelos usuários
Outros Tipos: Preço atual + valor de Bids dados pelos usuarios

Preço minimo para ganhar :

" />
(Nota: Preço minimo para ganahr deve ser inferior a preço acessível mínimo.)

" /> />

" /> " />

```

Diley007

leilao, lance demorando para ser computado

Column count doesn't match value count at row 1