ma5ect Posted October 12, 2008 Share Posted October 12, 2008 can any1 work out why the second query doesnt work <?php require_once('Connections/mysql_connect.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO `assignment submission sheet` (`Student number`, `Pathway / Course`, `Essay only`, `Marking tutor name`, `Module unit title`, `Module number`, `Assignment title`) VALUES (%s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['Student_number'], "int"), GetSQLValueString($_POST['Pathway__Course'], "text"), GetSQLValueString($_POST['Essay_only'], "int"), GetSQLValueString($_POST['Marking_tutor_name'], "text"), GetSQLValueString($_POST['Module_unit_title'], "text"), GetSQLValueString($_POST['Module_number'], "text"), GetSQLValueString($_POST['Assignment_title'], "text")); mysql_select_db($database_mysql_connect, $mysql_connect); $Result1 = mysql_query($insertSQL, $mysql_connect) or die(mysql_error()); $insertGoTo = "submits.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } mysql_select_db($database_mysql_connect, $mysql_connect); $query_Recordset1 = "SELECT * FROM `assignment submission sheet`"; $Recordset1 = mysql_query($query_Recordset1, $mysql_connect) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); mysql_select_db($database_mysql_connect, $mysql_connect); $query_Recordset2 = "SELECT * FROM robsfiles"; $Recordset2 = mysql_query($query_Recordset2, $mysql_connect) or die(mysql_error()); $row_Recordset2 = mysql_fetch_assoc($Recordset2); $totalRows_Recordset2 = mysql_num_rows($Recordset2); if(isset($_POST['robsfiles']) && $_FILES['userfile']['size'] > 0) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; $fp = fopen($tmpName, 'r'); $content = fread($fp, filesize($tmpName)); $content = addslashes($content); fclose($fp); if(!get_magic_quotes_gpc()) { $fileName = addslashes($fileName); } $query = "INSERT INTO robsfiles (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')"; mysql_query($query) or die('Error, query failed'); echo "<br>File $fileName uploaded<br>"; } ?> Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted October 12, 2008 Share Posted October 12, 2008 Not enough information for a meaningful answer... What do you mean by "doesn't work?" Do you get any errors? How do you know it doesn't work? Have you done any debugging? Ken Quote Link to comment Share on other sites More sharing options...
ma5ect Posted October 12, 2008 Author Share Posted October 12, 2008 just states query failed...the second query Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted October 12, 2008 Share Posted October 12, 2008 Change <?php mysql_query($query) or die('Error, query failed'); ?> to <?php mysql_query($query) or die("Error, query failed: $query<br>" . mysql_error()); ?> This should give you more information as to why the query failed. Ken 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.