Create a single comma separated list to echo from mysqli results

Question

$get_top10 = mysqli_query($con, "SELECT name, daily_points, daily_win FROM players WHERE daily_points > 0 ORDER BY daily_points DESC LIMIT 10");

I am needing a string like: name, daily_points, daily_win, name, daily_points, daily_win (etc up to 10 records)

php 7.4.27 mysql 5.6.51-cll-lve

This did the trick, let me know if there is a better or preferred method.

$sql = ("SELECT name, daily_points, daily_win FROM players WHERE daily_points > 0 ORDER BY daily_points DESC LIMIT 10");
        $result = mysqli_query($con, $sql);

        if (mysqli_num_rows($result)) {
            while ($row = mysqli_fetch_assoc($result)) {
                echo "{$row['name']},{$row['daily_points']},{$row['daily_win']},";
            }
        }

With $row being *array*, your question is not about database select but about arrays — Your Common Sense, May 03 '22 at 05:24

score -1 · Answer 1 · answered May 03 '22 at 04:45

-1

you can try this code it will concatenate your php variable to html ',' and it's a preferred method

  $sql = ("SELECT name, daily_points, daily_win FROM players WHERE daily_points > 0 ORDER BY daily_points DESC LIMIT 10");
            $result = mysqli_query($con, $sql);
    
            if (mysqli_num_rows($result)) {
                while ($row = mysqli_fetch_assoc($result)) {
                     echo $row['name'].','.$row['daily_points'].','.$row['daily_win'];
                }
            }

answered May 03 '22 at 04:45

Dotsquares

755
1
2
10

Nowhere it's a preferred method. – Your Common Sense May 03 '22 at 05:23
it's a preferred method. – Dotsquares May 03 '22 at 05:26
Unfortunately, it's just a superstition. One can use anything they prefer, all methods to concatenate variables into a string are equally acceptable. – Your Common Sense May 03 '22 at 05:50
yes, you are right we can do both code for the same task but according to me both method are fine and in case i will find any other method for the same i will definitely post here – Dotsquares May 03 '22 at 05:59

Create a single comma separated list to echo from mysqli results

1 Answers1