how to output INT values with proper commas from a mysql table?

Asked Mar 12 '20 at 18:07

Active Mar 12 '20 at 18:17

Viewed 28 times

people. I have Ajax/Jquery to output values from a MySQL table, but I am receiving the values with no commas. Instead of 10,000, I receive 10000. What can I do to fix this?

This is one of the Ajax/Jquery calls code:

$('#red').on('click', function() {
  var colorId = $(this).attr("id");

  $.ajax({
    "url": "tables.php",
    "data": {
      "color": colorId
    },
    success: function(response) {
      response = Number(response);
      $("#redr").text(response);
      console.log(response);

This will pass the variable and output the votes of the "red" color in my MySQL table, which columns are: city, color, votes.

edited Mar 12 '20 at 18:17

Rory McCrossan

331,213
40
305
339

asked Mar 12 '20 at 18:07

Joe Smith

https://stackoverflow.com/questions/2901102/how-to-print-a-number-with-commas-as-thousands-separators-in-javascript – GrumpyCrouton Mar 12 '20 at 18:31
https://stackoverflow.com/questions/4582562/how-can-i-add-commas-to-numbers-in-php – GrumpyCrouton Mar 12 '20 at 18:31
1

You can use mySQL's format function to return formatted string for your votes: FORMAT(votes, 2) – Nawed Khan Mar 12 '20 at 18:35

how to output INT values with proper commas from a mysql table?

0 Answers0