I can’t separate the array by commas

implode(",", [500,756]) will definitely return "500,756", therefore you have some other problem.

If the field type of the ‘num’ field is a numeric type such as MySQL’s INT, then MySQL or PHP might try and convert this string to a number and so "500,756" could become 500.

Check the data type of the ‘num’ field in the ‘number’ table. To store the string you want to store it needs to be a string type such as VARCHAR. Or if you’re trying to store a number with stuff after the decimal point make sure it’s e.g. a FLOAT / DECIMAL, etc. and add the value using a decimal point, e.g. 500.756.

If you need further help, show the CREATE TABLE output for your table

Related Posts:

  1. Undefined function mysql_connect()
  2. MySQL “Or” Condition
  3. the_date() not working
  4. Transaction when using WP functions rather than vanilla SQL?
  5. Can i use php sql functions instead of $wpdb?
  6. How to validate WordPress generated password in DB using PHP?
  7. Custom query to get post names beginning with a digit
  8. How to make WordPress plugin check for database changes and then do something?
  9. How To Make Connection To WordPress Data Base In A Plugin?
  10. Jquery ajax to custom php file: returning blank data
  11. Add value to usermeta without removing previous values?
  12. How can I call a row of user specific data from a custom table added to the WP Database
  13. How to merge local and live databases?
  14. How to track a users progress through pages by inserting data into WordPress Database?
  15. the_author_meta not working
  16. Performance issues with large website [closed]
  17. Create a quick start wordpress installation [closed]
  18. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  19. theme options echoing multiple times
  20. PHP/MySQL issues when running WP on EC2 cloud [closed]
  21. WordPress 3 – how are passwords stored and how do I compare to them?
  22. mysqli_real_connect() – authentication method unknown to the client Warnings
  23. How to create another version of my site based on the same database
  24. how to echo all tables that start with a prefix
  25. Do I need to prepare query before get_results(), get_row() and get_var()?
  26. How to create and work with custom data / tables (i.e., for arbitrary data)?
  27. Looking for most performant way to execute several similar WP queries within shortcodes
  28. How to select WooCommerce products by post_meta and order them
  29. PHP code inside shortcodes
  30. Show MySQL errors that occur when I excute $wpdb->insert()
  31. Remove one value in dismissed_wp_pointers?
  32. Accessing data from a non-WP database/table within a page content
  33. I want to select the from values from database in WordPress? [closed]
  34. WordPress not reflecting changed of the database
  35. User management system similar to wordpress one?
  36. How can I fix WordPress installation errors?
  37. SQL Injection blocked by firewall
  38. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  39. How can I save unique user data on my site? [closed]
  40. Ordering users by custom user meta
  41. Long running queries
  42. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  43. Not connecting to database in file with multiple MySQL connections
  44. Way to bulk make all my tags lowercase?
  45. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  46. Multiple meta_key in one global $wpdb;
  47. Custom array from a query only write the last row of the query
  48. WordPress member notification
  49. WordPress Block developer from exporting Database via PHP
  50. php include not working in custom page
  51. How do I display offsite database info on my wordpress site?
  52. Most commented posts by time period (last 12h, last 24h and etc)
  53. Use $wpdb or other PHP script method to find/replace in WP database
  54. email alert for product availability
  55. Issue with fetching mysql data and displaying results via shortcode in webpage
  56. Custom route and query
  57. How to unserialize data from MySQL
  58. How do I prepare strings for insertions as values into a MySQL table?
  59. Known Issues in WordPress When Upgrading PHP to ver 7
  60. add category to posts with tag wordpress
  61. How can I Use 2 databases with one WordPress install
  62. Edit Account – read and write to MySQL
  63. Why won’t this wpdb get_results query return results?
  64. Why when I create a new post I found 2 record related to this post into the posts database table?
  65. mySQL queries are executed twice on wordpress website
  66. Most viewed posts in WordPress
  67. Modify WooCommerce used to get all orders in dashboard
  68. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  69. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  70. WordPress low speed after migrating to new host
  71. Get mysql data for Quick Edit panel
  72. AWS Lightsail WordPress – connect to database on instance using mysqli
  73. call to undefined function mysql_connect
  74. Weird fonts showing which are coming from database
  75. WordPress Bad Request Error 400
  76. I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  77. What is the correct way to search 3 custom fields only in WordPress?
  78. cant insert data in a custom table in phpmyadmin
  79. How to import woocommerce custom fields data into another site?
  80. Change upload URL by mime type
  81. autocomplete in wordpress using ajax with json-data
  82. Unexpected behavior when trying to manually install WordPress on macOS Sierra
  83. WordPress post insertion from PHP file
  84. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  85. Query doesn’t display text data with apostrophes
  86. I want show only data for today
  87. Rewrite SQL query as a prepared statement and use in foreach loop
  88. SQL Query Search page
  89. Include a custom field in mysql query
  90. Insert double entry in DB
  91. Splitting One Big WordPress Site into Multiple Small Sites
  92. How to pass username into form that sends data to database
  93. How to edit the default database of WordPress [closed]
  94. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  95. Execute multiple PHP Snippets causes error?
  96. what to do after instlling cyberpanel on VPS
  97. running an existing WordPress site from Visual Studio Code?
  98. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax [closed]
  99. Updates applied to staging WordPress site affecting production even with different databases
  100. WordPress Query with meta_key and order by another meta_key