Skip to content Skip to sidebar Skip to footer

Sql Syntax Error In Mysql

I'm inserting value to my MySQL table from php as: $journey = $_POST['way']; $from = $_POST['from']; $to = $_POST['to']; $dpdt = $_POST['dp_date']; $rtdt = $_POST['rt_date']; $fare

Solution 1:

`from`='$from', `to`='$to'

FROM is reserved word use backtick around it.

Solution 2:

FROM is reserved keyword and you should not use it. Refer Here

Solution 3:

'from' and 'to' are reserve words

Try to do like this

[from] = 'Aurangabad', [to] ='Kashmir'

Solution 4:

FROM is a SQL-Keyword. You must not use that without delimiters as a column name.

Post a Comment for "Sql Syntax Error In Mysql"