forumsharry Posted December 5, 2007 Share Posted December 5, 2007 i have problem in this code as the query under this page is not running and hard for me to understand tghe code for page is as follow my some one can help me to understand ths code code function .php <?php session_start(); include '../includes/config.php'; include '../includes/default.css'; include 'auth.php'; $edit = $_GET['edit']; $which = $_GET['which']; $return = $_GET['return']; $id = $_GET['id']; $eg1 = "$which$id"; if ($eg1 == SETTINGS1){include 'lock.php';} $eg2 = "$which$id"; if ($eg2 == ADMINISTRATORS1){include 'lock.php';} $eg3 = "$which$id"; if ($eg3 == ANNOUNCEMENTS1){include 'lock.php';} $eg4 = "$which$id"; if ($eg3 == TICKET_SUBJECTS1){include 'lock.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']; $k = $_POST['11']; $l = $_POST['12']; $m = $_POST['13']; $n = $_POST['14']; $o = $_POST['15']; $p = $_POST['16']; $q = $_POST['17']; $r = $_POST['18']; $s = $_POST['19']; $t = $_POST['20']; if ($special == 'split'){ $pieces = explode("/", $a); $a = $pieces[0]; $b = $pieces[1]; if (empty($b)) {$b = '/';} } if ($jump == tru) { $ticket_status = $_POST['ticket_status']; $jump_id = $_POST['jump_id']; $sql = "UPDATE TICKETS SET STATUS ='$ticket_status' WHERE ID = '$jump_id'"; $query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error()); } if ($email == tru) { $a = htmlspecialchars($_POST["1"]); $b = htmlspecialchars($_POST["2"]); } if ($isupload == tru) { $c = $HTTP_POST_FILES['3']['name']; if (empty($c)){$c = 'No Image Available';}else{include '../includes/upload.php';} } ///////////////////////////////////////////////// if ($more == register) { if (empty($a)){$message = 'Username cannot be empty, please try again.'; include 'status.php'; die();} if (empty($b)){$message = 'Passwords cannot be empty, please try again.'; include 'status.php'; die();} if (empty($c)){$message = 'Password confirmation cannot be emty, please try again.'; include 'status.php'; die();} $SQL = "SELECT * from MEMBERS WHERE USERNAME = '$a'"; $result = mysql_query( $SQL ); while( $row = mysql_fetch_array( $result ) ) { $user = $row["USERNAME"]; $pass = $row["PASSWORD"]; } if ($a == $user) {$message = 'Sorry, this email address is currently being used. If you have forgotten your password, click HERE'; include 'status.php';die();} if ($b == $c) {$c=$nil;} else {$message = 'Passwords do not match, please try again.'; include 'status.php'; die();} } ///////////////////////////////////////////////// if (empty($a)) {$a = 'temp';} 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($l)) {$lc = $no; } else {$lc=',';} if (empty($m)) {$mc = $no; } else {$mc=',';} if (empty($n)) {$nc = $no; } else {$nc=',';} if (empty($o)) {$oc = $no; } else {$oc=',';} if (empty($p)) {$pc = $no; } else {$pc=',';} if (empty($q)) {$qc = $no; } else {$qc=',';} if (empty($r)) {$rc = $no; } else {$rc=',';} if (empty($s)) {$sc = $no; } else {$sc=',';} if (empty($t)) {$tc = $no; } else {$tc=',';} 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="=";} if (empty($k)) {$t11=$nono; $q1 = $abc; $q2 = $def;}else{$q1k="'"; $q2k="=";} if (empty($l)) {$t12=$nono; $q1 = $abc; $q2 = $def;}else{$q1l="'"; $q2l="=";} if (empty($m)) {$t13=$nono; $q1 = $abc; $q2 = $def;}else{$q1m="'"; $q2m="=";} if (empty($n)) {$t14=$nono; $q1 = $abc; $q2 = $def;}else{$q1n="'"; $q2n="=";} if (empty($o)) {$t15=$nono; $q1 = $abc; $q2 = $def;}else{$q1o="'"; $q2o="=";} if (empty($p)) {$t16=$nono; $q1 = $abc; $q2 = $def;}else{$q1p="'"; $q2p="=";} if (empty($q)) {$t17=$nono; $q1 = $abc; $q2 = $def;}else{$q1q="'"; $q2q="=";} if (empty($r)) {$t18=$nono; $q1 = $abc; $q2 = $def;}else{$q1r="'"; $q2r="=";} if (empty($s)) {$t19=$nono; $q1 = $abc; $q2 = $def;}else{$q1s="'"; $q2s="=";} if (empty($t)) {$t20=$nono; $q1 = $abc; $q2 = $def;}else{$q1t="'"; $q2t="=";}*/ $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 $q2j$q1j$j$q1j$kc $t11 $q2k$q1k$k$q1k$lc $t12 $q2l$q1l$l$q1l$mc $t13 $q2m$q1m$m$q1m$nc $t14 $q2n$q1n$n$q1n$oc $t15 $q2o$q1o$o$q1o$pc $t16 $q2p$q1p$p$q1p$qc $t17 $q2q$q1q$q$q1q$rc $t18 $q2r$q1r$r$q1r$sc $t19 $q2s$q1s$s$q1s$tc $w "; /*sql"INSERT INTO `settings` ( `ID` , `USERNAME` , `PASSWORD` , `IP` , `PATH` , `PAGE_TITLE` , `EMAIL_SUBJECT` , `EMAIL_REPLY` , `TEMPLATE` ) VALUES ( NULL , 'admin', 'admin', '', '', '', '', '', '' ), ( NULL , '', '', '', '', '', '', '', 'default' )";*/ $query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error()); $variable = "$return.php?message=$message"; include 'resend.php'; ?> and error:= Notice: Use of undefined constant SETTINGS1 - assumed 'SETTINGS1' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 13 Notice: Use of undefined constant ADMINISTRATORS1 - assumed 'ADMINISTRATORS1' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 15 Notice: Use of undefined constant ANNOUNCEMENTS1 - assumed 'ANNOUNCEMENTS1' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 17 Notice: Use of undefined constant TICKET_SUBJECTS1 - assumed 'TICKET_SUBJECTS1' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 19 Notice: Undefined index: 2 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 22 Notice: Undefined index: 3 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 23 Notice: Undefined index: 4 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 24 Notice: Undefined index: 5 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 25 Notice: Undefined index: 6 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 26 Notice: Undefined index: 7 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 27 Notice: Undefined index: 8 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 28 Notice: Undefined index: 9 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 29 Notice: Undefined index: 10 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 30 Notice: Undefined index: 11 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 31 Notice: Undefined index: 12 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 32 Notice: Undefined index: 13 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 33 Notice: Undefined index: 14 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 34 Notice: Undefined index: 15 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 35 Notice: Undefined index: 16 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 36 Notice: Undefined index: 17 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 37 Notice: Undefined index: 18 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 38 Notice: Undefined index: 19 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 39 Notice: Undefined index: 20 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 40 Notice: Undefined variable: special in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 42 Notice: Use of undefined constant tru - assumed 'tru' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 51 Notice: Undefined variable: jump in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 51 Notice: Use of undefined constant tru - assumed 'tru' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 62 Notice: Undefined variable: email in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 62 Notice: Use of undefined constant tru - assumed 'tru' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 67 Notice: Undefined variable: isupload in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 67 Notice: Use of undefined constant register - assumed 'register' in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 73 Notice: Undefined variable: more in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 73 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 100 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 101 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 102 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 103 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 104 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 105 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 106 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 107 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 108 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 109 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 110 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 111 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 112 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 113 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 114 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 115 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 116 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 117 Notice: Undefined variable: no in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 118 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 121 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 121 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 121 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 122 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 122 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 122 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 123 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 123 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 123 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 124 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 124 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 124 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 125 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 125 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 125 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 126 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 126 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 126 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 127 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 127 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 127 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 128 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 128 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 128 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 129 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 129 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 129 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 130 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 130 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 130 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 131 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 131 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 131 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 132 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 132 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 132 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 133 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 133 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 133 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 134 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 134 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 134 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 136 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 136 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 136 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 137 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 137 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 137 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 138 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 138 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 138 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 139 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 139 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 139 Notice: Undefined variable: nono in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 140 Notice: Undefined variable: abc in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 140 Notice: Undefined variable: def in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 140 Notice: Undefined variable: t1 in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 143 Notice: Undefined variable: q2b in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 144 Notice: Undefined variable: q1b in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 144 Notice: Undefined variable: q1b in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 144 Notice: Undefined variable: q2c in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 145 Notice: Undefined variable: q1c in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 145 Notice: Undefined variable: q1c in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 145 Notice: Undefined variable: q2d in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 146 Notice: Undefined variable: q1d in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 146 Notice: Undefined variable: q1d in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 146 Notice: Undefined variable: q2e in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 147 Notice: Undefined variable: q1e in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 147 Notice: Undefined variable: q1e in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 147 Notice: Undefined variable: q2f in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 148 Notice: Undefined variable: q1f in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 148 Notice: Undefined variable: q1f in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 148 Notice: Undefined variable: q2g in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 149 Notice: Undefined variable: q1g in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 149 Notice: Undefined variable: q1g in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 149 Notice: Undefined variable: q2h in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 150 Notice: Undefined variable: q1h in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 150 Notice: Undefined variable: q1h in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 150 Notice: Undefined variable: q2i in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 151 Notice: Undefined variable: q1i in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 151 Notice: Undefined variable: q1i in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 151 Notice: Undefined variable: q2j in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 152 Notice: Undefined variable: q1j in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 152 Notice: Undefined variable: q1j in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 152 Notice: Undefined variable: q2k in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 153 Notice: Undefined variable: q1k in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 153 Notice: Undefined variable: q1k in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 153 Notice: Undefined variable: q2l in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 154 Notice: Undefined variable: q1l in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 154 Notice: Undefined variable: q1l in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 154 Notice: Undefined variable: q2m in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 155 Notice: Undefined variable: q1m in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 155 Notice: Undefined variable: q1m in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 155 Notice: Undefined variable: q2n in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 156 Notice: Undefined variable: q1n in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 156 Notice: Undefined variable: q1n in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 156 Notice: Undefined variable: q2o in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 158 Notice: Undefined variable: q1o in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 158 Notice: Undefined variable: q1o in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 158 Notice: Undefined variable: q2p in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 159 Notice: Undefined variable: q1p in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 159 Notice: Undefined variable: q1p in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 159 Notice: Undefined variable: q2q in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 160 Notice: Undefined variable: q1q in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 160 Notice: Undefined variable: q1q in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 160 Notice: Undefined variable: q2r in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 161 Notice: Undefined variable: q1r in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 161 Notice: Undefined variable: q1r in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 161 Notice: Undefined variable: q2s in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 162 Notice: Undefined variable: q1s in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 162 Notice: Undefined variable: q1s in G:\Program Files\EasyPHP 2.0b1\home\tem\admin\function.php on line 162 Cannot query the database. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='default' WHERE ID ' at line 2 help me to under stand this query if u need any more info please leave a coment on it Quote Link to comment Share on other sites More sharing options...
jaymc Posted December 5, 2007 Share Posted December 5, 2007 All of those errors are light warnings, in other words, they dont cause the php script to die undefined constant means you havent put the ' ' in the likes of $data['keynamehere'] If you put them in, will sort that out. Or you could disable error reporting. MYSQL ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='default' WHERE ID ' at line 2 Well.. read what its telling you Your code is nuts, needs serious revision. MYSQL errors, check syntax, Im not doing it for you, mysql is telling you what it doesnt like and WHERE it doesnt like it, excuse the pun Good luck Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.