Clone512

Why does this always yield a 502 proxy error? <?php require("connect.php"); include("design/header.php"); include("design/navigation.php"); if(!isset($_SESSION['user'])) { die("You must <a href='' style='color:blue'>login</a> first!"); } $user = $_SESSION['user']; $id = $_GET['id']; if($id) { $query = mysql_query("SELECT * FROM inbox WHERE id='$id'"); while ($row = mysql_fetch_assoc($query)) { $from = $row['from']; $to = $row['to']; $message = $row['message']; $sbj = $row['subject']; $title = $sbj; if(substr($title, 1, 3)!="RE:") { $title = "RE: ".$title; } if($to != $user) { echo "You cannot view other peoples' mail!"; } else { $t = $row['sent']; $secs = time()-$t; $minutes = 0; $seconds = 0; $hours = 0; if($secs >= 60) { for($x=0;$x<=$secs;$x++) { if($x == ($minutes + 1)*60) { $minutes++; $seconds = $secs - ($minutes * 60); } } if($minutes >= 60) { $storemin = $minutes; for($x=0;$x<=$storemin;$x++) { if($x == ($hours + 1)*60) { $hours++; $minutes = $minutes - 60; } } } } $mode = $_GET['mode']; $submit = $_POST['submit']; if($mode == 'send' && $submit) { $id = $_GET['id']; $query = mysql_query("SELECT * FROM inbox WHERE id='$id'"); $row = mysql_fetch_assoc($query); $t = time(); $to = $row['from']; $subject = $_POST['subject']; $reply = $_POST['reply']; mysql_query("INSERT INTO inbox VALUES ('$t', '$to', '$user', '$subject', '$reply', '')"); echo "<script language='javascript'>window.location='inbox.php';</script>"; } if($mode && $mode == 'reply') { if($hours > 1) { $d = date("m/ d/ y"); $sPattern = '/\s*/m'; $d = preg_replace( $sPattern, '', $d ); $m = "Sent by $user at $d"; if(strlen($m)!=52) { $alt = false; for($x=0;$x<52;$x++) { if(strlen($m)==52) { break; } if($alt) { $m = "-".$m; } else { $m = $m."-"; } $alt = !$alt; } } echo "<form action='message.php?id=$id&mode=send' method='POST'><center><b>Sent by $from $hours Hours, $minutes Minutes, and $seconds Seconds ago:</b><br><input type='text' size='57' name='subject' value='$title'><br><textarea cols=50 rows=9>$message</textarea><br><br><br> <textarea cols=50 rows=9 name='reply'>\n\n\n$m\n$message</textarea><br> <input type='submit' value='Send' name='submit'></form>"; } if($hours==1) { $d = date("m/ d/ y"); $sPattern = '/\s*/m'; $d = preg_replace( $sPattern, '', $d ); $m = "Sent by $user at $d"; if(strlen($m)!=52) { $alt = false; for($x=0;$x<52;$x++) { if(strlen($m)==52) { break; } if($alt) { $m = "-".$m; } else { $m = $m."-"; } $alt = !$alt; } } echo "<form action='message.php?id=$id&mode=send' method='POST'><center><b>Sent by $from $hours Hour, $minutes Minutes, and $seconds Seconds ago:</b><br><input type='text' size='57' name='subject' value='$title'><br><textarea cols=50 rows=9>$message</textarea><br><br><br> <textarea cols=50 rows=9 name='reply'>\n\n\n$m\n$message</textarea><br> <input type='submit' value='Send' name='submit'></form>"; } if($minutes > 0 && $hours < 1) { $d = date("m/ d/ y"); $sPattern = '/\s*/m'; $d = preg_replace( $sPattern, '', $d ); $m = "Sent by $user at $d"; if(strlen($m)!=52) { $alt = false; for($x=0;$x<52;$x++) { if(strlen($m)==52) { break; } if($alt) { $m = "-".$m; } else { $m = $m."-"; } $alt = !$alt; } } echo "<form action='message.php?id=$id&mode=send' method='POST'><center><b>Sent by $from $minutes Minutes, and $seconds Seconds ago:</b><br><input type='text' size='57' name='subject' value='$title'><br><textarea cols=50 rows=9>$message</textarea><br><br><br> <textarea cols=50 rows=9 name='reply'>\n\n\n$m\n$message</textarea><br> <input type='submit' value='Send' name='submit'></form>"; } if ($minutes == 0) { $d = date("m/ d/ y"); $sPattern = '/\s*/m'; $d = preg_replace( $sPattern, '', $d ); $m = "Sent by $user at $d"; if(strlen($m)!=52) { $alt = false; for($x=0;$x<52;$x++) { if(strlen($m)==52) { break; } if($alt) { $m = "-".$m; } else { $m = $m."-"; } $alt = !$alt; } } echo "<form action='message.php?id=$id&mode=send' method='POST'><center><b>Sent by $from $seconds Seconds ago:</b><br><textarea cols=50 rows=9>$message</textarea><br><br> <textarea cols=50 rows=9 name='reply'>\n\n\n$m\n$message</textarea><br> <input type='submit' value='Send' name='submit'></form>"; } } else { if($hours==1) { echo "<center><b>Sent by $from $hours Hour, $minutes Minutes, and $seconds Seconds ago:</b><br><textarea cols=50 rows=9>$message</textarea><br> <input type='button' value='Delete' onclick='javascript:window.location=\"delete.php?id=$id\"'><input type='button' value='Reply' onclick='javascript:window.location=\"message.php?id=$id&mode=reply\"'>"; } if($hours > 1) { echo "<center><b>Sent by $from $hours Hours, $minutes Minutes, and $seconds Seconds ago:</b><br><br>Subject:<br>$sbj<br><textarea cols=50 rows=9>$message</textarea><br> <input type='button' value='Delete' onclick='javascript:window.location=\"delete.php?id=$id\"'><input type='button' value='Reply' onclick='javascript:window.location=\"message.php?id=$id&mode=reply\"'>"; } if($minutes > 0 && $hours < 1) { echo "<center><b>Sent by $from $minutes Minutes, and $seconds Seconds ago:</b><br><textarea cols=50 rows=9>$message</textarea><br> <input type='button' value='Delete' onclick='javascript:window.location=\"delete.php?id=$id\"'><input type='button' value='Reply' onclick='javascript:window.location=\"message.php?id=$id&mode=reply\"'>"; } if ($minutes == 0 && $hours == 0) { echo "<center><b>Sent by $from $seconds Seconds ago:</b><br><textarea cols=50 rows=9>$message</textarea><br> <input type='button' value='Delete' onclick='javascript:window.location=\"delete.php?id=$id\"'><input type='button' value='Reply'>"; } } } } } include("design/footer.php"); ?>

Bump

Ok, did that here's the error I got: 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 'to='Testusr'' at line 1. But the problem is I don't get what's wrong.

For some reason I get this error from this script (yes, connect.php connects to the database and selects a database, without the where statement, it works fine, yes the field, to exists): <?php include("design/header.php"); require("connect.php"); $user = $_SESSION['user']; $query = mysql_query("SELECT * FROM inbox WHERE to='$user'"); $messages = mysql_num_rows($query); if($messages==0) { echo "You have no messages."; } else { echo "Test worked."; } include("design/footer.php"); ?>