Why can't I add data into the table?

[Dhin]

How can I fix this?


This is the warning:

Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\pos\addmessage.php  on line 4
 

This is the code:

<?php
mysql_connect("localhost","root","");
@mysql_select_db("pointofsales") or die ("Unable to connect");;
$sql=mysql_query("INSERT INTO products(prodid, prodname, description, amount, stocks)VALUES('$_POST[ProdID]','$_POST[ProdName]','$_POST[Description]','$_POST[Amount]','$_POST[Stocks]')";
mysql_query($sql);
mysql_close();
echo "Record is added successfully";
?>
 

I'm a beginner. I would appreciate your help. Thanks!

[Mayur2007]

Hello,

Try the below code

<?php
    mysql_connect("localhost","root","");
    @mysql_select_db("pointofsales") or die ("Unable to connect");;
    $sql = "INSERT INTO products(prodid, prodname, description, amount, stocks)
                            VALUES ('".$_POST[ProdID]."',
                                    '".$_POST[ProdName]."',
                                    '".$_POST[Description]."',
                                    '".$_POST[Amount]."',
                                    '".$_POST[Stocks]."');";
    $sql=mysql_query($sql);
    if(mysql_query($sql)) {    
        echo "Record is added successfully";
    } else {
        echo "There is some error";
    }
    mysql_close();
?>
 

[MrMancunian]

Look at line 3, there's a double semicolon... The error tells you it's row 4 and most of the times, the error is one row earlier.

Steven