JSON encoding

[franzwarning]

Hi, here is my script to get the usernames of a few members. I'm trying to encode it using JSON.

<?php
require("connect.php");


$date = date("Y-m-d");
	$picarray = array();
        $handle = opendir ('pqimages/'.$date.'/');
        while (false !== ($file = readdir($handle))) {
            if($file != "." && $file != "..") {
			$getusername = mysql_query("SELECT * FROM users WHERE lastupload='pqimages/".$date."/".$file."'");
			while ($row = mysql_fetch_assoc($getusername)){

			$usernames= $row['username'];
			$people = array();
			$people[] = $usernames;

			echo json_encode($people); 

			}
            }


        }


?>

the only problem is the output:["mumford"]["franzwarning"]["tetris"]

when it should be: ["mumford", "franzwarning", "tetris"]

 

any recommendations?

Thanks,

George

[gristoi]

Try moving

$people = array();

Just before your while loop. At the moment you are creating a new array on every loop instead off adding to one array