Mysql query working in phpmyadmin but not in a php script

Question

I've written this mysql query, but for some weird reason it's working in phpmyadmin. When I run this query in php it doesn't work.

mysql

$sql = "INSERT INTO msw_posts (user_id, user_name, title, vak, richting, type, post_date, points, views, likes, dislikes, year, keywords, discription)
VALUES ('1', 'test user', 'test', 'bio', 'aso', 'cursus', '2016-05-04', '0', '0', '0', '0', '3', 'test', 'discr')";

PHP

                    if (mysqli_query($dbConn, $sql)) {
                        echo "New record created successfully";
                        //uploaden en checken of upload in orde is
                        if(move_uploaded_file($_FILES['bestand']['tmp_name'], $dir.$file)){
                            header("Location: uploaden.php?type=ok");
                        }else{
                            header("Location: uploaden.php?type=failed_uploading");
                        }
                    } else {
                        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
                    }

Thanks for your advice or help!!

type is a MySQL reserved word and can't be used for a table or column name if it isn't enclosed in backticks (`); year is a mysql reserved word, likewise — Mark Baker
– Mark Baker, Commented May 5, 2016 at 7:08
Try writing your field names with ` (It is the symbol before Num 1 key) Like: INSERT INTO msw_posts (`user_id`, `user_name`, ... Sometimes it confuses with Existing Command. — TipuZaynSultan
– TipuZaynSultan, Commented May 5, 2016 at 7:10
Possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — andrewsi
– andrewsi, Commented May 13, 2016 at 1:24

Dipanwita Kundu · Accepted Answer · 2016-05-05 07:22:35Z

1

use back-quotes("`") on your field name as you have used many of the mysql reserve keyword in your field name

answered May 5, 2016 at 7:22

Dipanwita Kundu

1,6451 gold badge10 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Mysql query working in phpmyadmin but not in a php script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related