Ver Mensaje Individual
  #4 (permalink)  
Antiguo 23/05/2013, 11:44
nerezza
 
Fecha de Ingreso: abril-2008
Mensajes: 13
Antigüedad: 16 años
Puntos: 0
Respuesta: Problema Actualizar datos MySQL

Cita:
Iniciado por alex1084 Ver Mensaje
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';
?>