MySQL column count doesn’t match value count at row 1 [closed]

mysql_query("INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES('{$random}', '{$filename}', '{$extension}', '{$filelink}', '{$filesize}' '{$filepass}') ") or die(mysql_error());

You should add the missing comma after {$filesize}:

mysql_query("INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES(

Related Posts:

  1. Undefined function mysql_connect()
  2. Deprecated: mysql_connect()
  3. dbDelta support for FOREIGN KEY
  4. is it possible to run some php code within a wordpress page?
  5. How to correctly submit a search form and display the result in an independent page
  6. How to use update and delete query in wordpress
  7. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  8. How to add query vars with paginated URLs?
  9. Does WordPress cache get_user_meta() results?
  10. How to Join two tables from separate databases within WordPress
  11. Using Echo in ShortCode – Stuck
  12. MySQL query performed 4 times inside loop
  13. Show only one post for each author ( Page loads too slow )
  14. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  15. Install will not load: PHP does not have MYSQL installed
  16. Modern Tribe Calendar wp-query with meta query not working at all
  17. WP database error for comments_popup_link()
  18. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  19. No wp-config.php file on local install of wordpress – site still displays
  20. Use ajax to update_post_meta
  21. Insert all post IDs in new database table
  22. register_activation_hook isn’t adding table to DB
  23. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  24. What SQL / WordPress queries would need a nonce?
  25. Different database query in function.php using mysqli
  26. Converting MYSQL to WordPress $WPDB
  27. Why is variable not working on custom sql query using wpdb?
  28. Get WooCommerce product details and transfer them to a custom DB table
  29. How can I export posts with featured images, without download them
  30. How to securely provide a $_POST var in WP_Query with PHP 7?
  31. Create WP_Query to search for posts by their categories or their parent/child categories
  32. What is a valid parent for get_terms()?
  33. WSoD being caused by this piece of code
  34. How to display data from custom table in wordpress phpmyadmin
  35. Calculating a large number of MYSQL queries as customshort codes, slow
  36. Update results, Before deleting the related category [closed]
  37. Sum the total amount of a specific product purchased per user and display in table
  38. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  39. Weird 404 URL Problem – domain name being placed at end of urls
  40. wp query foreach deleting record returning only first or last item
  41. database sent to a JSON file
  42. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  43. $wpdb->insert() does not Insert record in a table
  44. Not connecting to database in file with multiple MySQL connections
  45. Way to bulk make all my tags lowercase?
  46. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  47. Custom array from a query only write the last row of the query
  48. php include not working in custom page
  49. Force Users To Relogin
  50. email alert for product availability
  51. Basic wpdb update question
  52. A $_POST should occur when submit form but is not?
  53. Custom route and query
  54. Pull MySQL data from multiple tables and merge into 1 PHP array
  55. How do I prepare strings for insertions as values into a MySQL table?
  56. Using CFDB7 vs Custom MySQL Database [closed]
  57. add category to posts with tag wordpress
  58. How can I Use 2 databases with one WordPress install
  59. Why won’t this wpdb get_results query return results?
  60. Adding data to custom wordpress database table
  61. select a single val though a table in wordpress
  62. populate select options from extra mysql table data
  63. Removal of all posts content in bulk, keeping the posts itself
  64. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  65. How to store checkbox data for individual users?
  66. WordPress low speed after migrating to new host
  67. AWS Lightsail WordPress – connect to database on instance using mysqli
  68. call to undefined function mysql_connect
  69. Usermeta data unserialize, extract and display in table in WordPress
  70. I can’t separate the array by commas
  71. Using wpdb to connect to a different database is not working
  72. How to edit content in WordPress and the Polylang – plugin? – with demosite
  73. How can i limit the number of posts to the most recent 6 in my query?
  74. Change upload URL by mime type
  75. Insert data from form to database
  76. (Who to follow) Twitter widget
  77. Prepared DB Query from _POST array
  78. How can I display a query in a page?
  79. How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
  80. Conditional statement within WP SQL query
  81. Passed variable gets undefined variable error on insert on next page
  82. How to set up an auto delete post?
  83. WordPress upload images not displaying
  84. two wordpress sites, two themes, one database, same content
  85. how to check for wordpress Query errors
  86. Insert double entry in DB
  87. Splitting One Big WordPress Site into Multiple Small Sites
  88. MySQL database migration to WordPress
  89. Custom query_posts() parameter
  90. MySQL update text field with ‘
  91. Query Concatenation
  92. Display total count of products in orders of a specific order status
  93. How to get a database field value from a WordPress table? [closed]
  94. Execute multiple PHP Snippets causes error?
  95. Error resetting database index using ALTER TABLE in $wpdb->query
  96. what to do after instlling cyberpanel on VPS
  97. Can’t insert into a database wordpress
  98. Updates applied to staging WordPress site affecting production even with different databases
  99. How to return count number from a wordpress database
  100. Trying to GET data with ajax from database and show in fullcalendar

Leave a Comment