Jump to content

Syntax error, cant seem to fix


illuz1on

Recommended Posts

Hey getting this error, cant seem to see why - anyone know ? :)

 

The file CTA Domains.txt has been uploadedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc)VALUES ('NULL', 'CTA Domains.txt', 'sadsadsa')' at line 1

<?php
include "db.php";
$target_path = "uploads/";
$name = basename( $_FILES['uploadedfile']['name']);
$desc1 = $_POST["desc1"];

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}


$addoffer = MYSQL_QUERY("INSERT INTO uploaddb (id,name,desc1)". "VALUES ('NULL', '$name', '$desc1')") or die (mysql_error ());
echo "Upload Successful:";
echo "Name: $name";
echo "Description: $desc1";

?>

Link to comment
https://forums.phpfreaks.com/topic/62638-syntax-error-cant-seem-to-fix/
Share on other sites

Cool thanks I fixed it, but now im having trouble getting the desc1 to be inserted, the $name is going in but not $desc1

 

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
Choose a file to upload: <input name="uploadedfile" type="file" /><br />
Description: </b><input type="text" name="desc1" size="40" maxlength="80" value="" />
<input type="submit" value="Upload File" />
</form>

 

<?php /* Created on: 7/27/2007 */ ?>
<html>
<body>
<?php
include "db.php";
$target_path = "uploads/";
$name = basename( $_FILES['uploadedfile']['name']);
$desc1 = $_POST["desc1"];

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}

$addoffer = MYSQL_QUERY("INSERT INTO uploaddb (id,name,desc1) VALUES ('NULL', '$name', '$desc1')") or die (mysql_error ());
echo "Upload Successful:<br>";
echo "Name: $name<br>";
echo "Description: $desc1<br>";

?>
</body>
</html>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.