MySql insertion error

Question

I have a mysql query as follows :

$sql = "
        INSERT INTO
            tbl_stopage
        SET
            bus_id = '$bid',
            stopage_name = '$info[stopage_name]',
            fare = '$info[fare]',
            from = 'Ghy'
    ";

But when I tried to execute the above query , it shows the following error :

DB Error.
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 'from = 'Ghy'' at line 7
INSERT INTO tbl_stopage SET bus_id = '1', stopage_name = 'Dergaon', fare = '123', from = 'Ghy'

xQbert · Accepted Answer · 2012-01-17 05:10:16Z

4

in SQL FROM is a reserved word try using from with the proper mySQL escape characters which I believe is `.

In addition, are all the "numeric" values actualy numbers in the database? if so you don't need the tics (') around them.

Overall if its not too late you may avoid future headaces simply by altering the table not to use keywords such as FROM, SELECT, WHERE, GROUP BY, ORDER BY etc.

answered Jan 17, 2012 at 5:10

xQbert

35.5k2 gold badges46 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nitish Over a year ago

Thanks xQbert, I changed from to source_station and it worked.

xkeshav · Accepted Answer · 2012-01-17 05:20:05Z

1

$sql = "INSERT INTO 
        tbl_stopage (`bus_id`,`stopage_name`,`fare`,`from`)               
        VALUES ('$bid','$info[stopage_name]','$info[fare]','Ghy')";

But it's better to use prepared statements.

edited Jan 17, 2012 at 5:20

xkeshav

54.2k47 gold badges183 silver badges255 bronze badges

answered Jan 17, 2012 at 5:12

falinsky

7,4454 gold badges34 silver badges59 bronze badges

Collectives™ on Stack Overflow

MySql insertion error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related