Get mysql error while inserting data

ghjk

I wan to add some data using php page to mysql db. But I got the error saying "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 'sql' at line 1". Could someone please help me.
This is my php code

Expand|Select|Wrap|Line Numbers

 
<?php
 
    if(isset($_POST['Submit'])){ 

    $VehicleNo = $_POST['VehicleNo'];

    $Type= $_POST['Type'];

    $Make=$_POST['Make'];

    $Model=$_POST['Model'];

    $Price=$_POST['Price'];

    $OwnerName=$_POST['OwnerName'];

    $ContactNo=$_POST['ContactNo'];

    $Email=$_POST['Email'];

    $Other=$_POST['Other'];
 
    // selected and uploaded a file

    if (($_FILES['image']) && $_FILES['image']['size'] > 0) { 
 
    // Temporary file name stored on the server

    $tmpName  = $_FILES['image']['tmp_name'];  
 
    // Read the file 

    $fp      = fopen($tmpName, 'r');

    $data = fread($fp, filesize($tmpName));

    $data = addslashes($data);

    fclose($fp);
 
      // Create the query and insert

      // into our database.

      //$query = "INSERT INTO tbl_images ";

      //$query .= "(image) VALUES ('$data')";

      //$results = mysql_query($query, $link);
 
      // Print results

      //print "Thank you, your file has been uploaded.";
 
    }

//

    $sql = "INSERT INTO vehicles('$VehicleNo','$data','$Price','$OwnerName','$ContactNo','$Email','$Type','$Make','$Model','$Other')"; 

    echo $sql;

    $result = mysql_query(sql);

    if (!$result) 

        {

            echo "Error in SQL query: " . mysql_error();

        }

        else{

            echo "Data successfully inserted!"; 

        }

    }

    // main else

    else{

?>
 
<table width="800" align="center" height="200" border="0" cellspacing="0" bgcolor="#EBE9ED">

  <tr>

    <td colspan="3"><?php //require_once 'common/hedder.php';?></td>

    </tr>

    <tr>

        <td width="200" colspan="2"><?php require_once 'common/left.php'; ?></td>

    </tr>

    <tr><td bgcolor="#EBE9ED">

    <form action="addVehicle.php" method="post" name="changer">

        <table align="center" bgcolor="#EBE9ED"  width="650" ><tr><td>

        <tr>

            <td>Vehicle No</td>

            <td><input name="VehicleNo" type="text" /></td>

            <td>Image</td>

            <td>

            <input name="MAX_FILE_SIZE" value="102400" type="hidden">

            <input name="image" accept="image/jpeg" type="file">

            </td>

        </tr>

        <tr>

            <td>Type</td>

            <td><?php GetVehicleType(); ?></td>

            <td>Vehicle Make</td>

            <td><?php GetVehicleMake(); ?> </td>

        </tr>

        <tr>

            <td>Model</td>

            <td><input type="text" name="Model"></td>

            <td>Year</td>

            <td><input name="Year" type="text" /></td>

        </tr>

        <tr>

            <td>Price</td>

            <td><input name="Price" type="text" /></td>

            <td>Owner Name</td>

            <td><input name="OwnerName" type="text" /></td>

        </tr>

        <tr>

            <td>Contact Number</td>

            <td><input name="ContactNo" type="text" /></td>

            <td>Email</td>

            <td><input name="Email" type="text" /></td>

        </tr>

        <tr><td colspan="4">

            <table><tr>

            <td>Other</td>

            <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

            <textarea name="Other" cols=48 rows=3 ></textarea></td>

            </tr></table></td>

        </tr>

        <tr><td align="right" colspan="4"><input type="submit"  class="btn" value="Submit" alt="Submit" height="30"  width="50" name="Submit"/></td></tr>

    </td></tr></table>

    </form>

    </td></tr>

    <tr>

    <td colspan="3" align="center"><?php require_once 'common/footer.php'; ?></td>

    </tr>

</table>

<?php } //close main else?>

Atli

Hey.

Line #39. You forgot the $ in the variable name.

ghjk

Thank You very much.

ghjk

Correct it. But still got an error.
Error in SQL query: 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 ''gfdg','','gdf','fgdf','gdf','hgf','Jeep','BMW',' dsfs','fdg')' at line 1

Atli

The INSERT query syntax is supposed to be:

Expand|Select|Wrap|Line Numbers

 
/* Either */

INSERT INTO `table`(`col1`, `colN`) VALUES('val1', 'valN')

/* Or */

INSERT INTO `table` VALUES(NULL, 'val1', 'valN')

(It's best to use the first version. Allows you to change the table later without having to alter all your queries as well.)

You just have

Expand|Select|Wrap|Line Numbers

INSERT INTO `table`('val1', 'valN')

Get mysql error while inserting data

✓ answered by Atli

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ