Cita:
Iniciado por alex1084
Cual es la sentencia perdon??????
Podrias mostrar tu consulta sql tal como la estas generando??
Porque sin duda esta mala
Que tal, discupa apenas estoy aprendiendo sobre la marcha, te pego todo el codigo de los archivos que se manejan,
settings.php
<form name="form1" method="post" action="app/function.php?which=SETTINGS&t1=URL&t2=PATH&return= settings<?php echo $x; ?>&t3=HOST&t4=USER&t5=RAK&t6=WSU&t7=DNR&t8=AUTOTER M">
query.php
<?php
$id = $row["ID"];
$url = $row["URL"];
$path = $row["PATH"];
$username = $row["USERNAME"];
$password = $row["PASSWORD"];
$ip = $row["IP"];
$host = $row['HOST'];
$rak = $row["RAK"];
$user = $row["USER"];
$receiver_email = $row["RECEIVER_EMAIL"];
$currency = $row["CURRENCY"];
$logo_url = $row["LOGO_URL"];
$success_url = $row["SUCCESS_URL"];
$cancel_url = $row["CANCEL_URL"];
$name = $row["NAME"];
$whmname = $row["WHMNAME"];
$monthly = $row["MONTHLY"];
$quarterly = $row["QUARTERLY"];
$semiannually = $row["SEMIANNUALLY"];
$annually = $row["ANNUALLY"];
$twoyears = $row["2YEARS"];
$freetrial = $row["FREETRIAL"];
$yy = $row["YY"];
$nn = $row["NN"];
$wsu = $row["WSU"];
$subdomain = $row["SUBDOMAIN"];
$sub = $row["SUB"];
$free = $row["FREE"];
$syn = $row["SYN"];
$dnr = $row["DNR"];
$from = $row["FROOM"];
$subject = $row["SUBJECT"];
$message = $row["MESSAGE"];
$ig = $row["IG"];
$paackage = $row["PACKAGE"];
$signupdate = $row["SIGNUPDATE"];
$payer_email = $row["PAYER_EMAIL"];
$nextpayment = $row["NEXTPAYMENT"];
$lastpayment = $row["LASTPAYMENT"];
$dn = $row["DOMAIN"];
$status = $row["STATUS"];
$cpw = $row["CPW"];
$subid = $row["SUBID"];
$s_signup = $row["S_SIGNUP"];
$s_cancel = $row["S_CANCEL"];
$s_modify = $row["S_MODIFY"];
$s_failure = $row["S_FAILURE"];
$s_payment = $row["S_PAYMENT"];
$s_eot = $row["S_EOT"];
$uni = $row["UNI"];
$autoterm = $row["AUTOTERM"];
?>
function.php
<?php
include '../../inc/sqlinf.php';
$a = $_POST['1'];
$b = $_POST['2'];
$c = $_POST['3'];
$d = $_POST['4'];
$e = $_POST['5'];
$f = $_POST['6'];
$g = $_POST['7'];
$h = $_POST['8'];
$i = $_POST['9'];
$j = $_POST['10'];
if ($edit == 'tru') {
$v ='UPDATE $which SET';
$w =" WHERE ID = '$id'";
}else{
$v ='INSERT INTO $which SET';
$w = $nil;
}
if (empty($b)) {$bc = $no; } else {$bc=',';}
if (empty($c)) {$cc = $no; } else {$cc=',';}
if (empty($d)) {$dc = $no; } else {$dc=',';}
if (empty($e)) {$ec = $no; } else {$ec=',';}
if (empty($f)) {$fc = $no; } else {$fc=',';}
if (empty($g)) {$gc = $no; } else {$gc=',';}
if (empty($h)) {$hc = $no; } else {$hc=',';}
if (empty($i)) {$ic = $no; } else {$ic=',';}
if (empty($j)) {$jc = $no; } else {$jc=',';}
if (empty($k)) {$kc = $no; } else {$kc=',';}
if (empty($a)) {$t1= $nono; $q1 = $abc; $q2 = $def;}else{$q1a="'"; $q2a="=";}
if (empty($b)) {$t2= $nono; $q1 = $abc; $q2 = $def;}else{$q1b="'"; $q2b="=";}
if (empty($c)) {$t3= $nono; $q1 = $abc; $q2 = $def;}else{$q1c="'"; $q2c="=";}
if (empty($d)) {$t4= $nono; $q1 = $abc; $q2 = $def;}else{$q1d="'"; $q2d="=";}
if (empty($e)) {$t5= $nono; $q1 = $abc; $q2 = $def;}else{$q1e="'"; $q2e="=";}
if (empty($f)) {$t6= $nono; $q1 = $abc; $q2 = $def;}else{$q1f="'"; $q2f="=";}
if (empty($g)) {$t7= $nono; $q1 = $abc; $q2 = $def;}else{$q1g="'"; $q2g="=";}
if (empty($h)) {$t8= $nono; $q1 = $abc; $q2 = $def;}else{$q1h="'"; $q2h="=";}
if (empty($i)) {$t9= $nono; $q1 = $abc; $q2 = $def;}else{$q1i="'"; $q2i="=";}
if (empty($j)) {$t10=$nono; $q1 = $abc; $q2 = $def;}else{$q1j="'"; $q2j="=";}
$sql = "$v
$t1 $q2a$q1a$a$q1a$bc
$t2 $q2b$q1b$b$q1b$cc
$t3 $q2c$q1c$c$q1c$dc
$t4 $q2d$q1d$d$q1d$ec
$t5 $q2e$q1e$e$q1e$fc
$t6 $q2f$q1f$f$q1f$gc
$t7 $q2g$q1g$g$q1g$hc
$t8 $q2h$q1h$h$q1h$ic
$t9 $q2i$q1i$i$q1i$jc
$t10 $qj$q1j$j$q1j$kc
$w
";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
$variable = "../$return.php";
include '../resend.php';
?>