I have this:
$pdo = new PDO("mysql:host=$host;dbname=$databaseName;charset=utf8", $user, $pass);
$query = "SELECT name FROM $tableName";
$stm = $pdo->prepare($query);
$stm->execute();
$array = $stm->fetchAll();
$firephp->log($array);
echo json_encode($array);
Result on ajax is:
[{"name":"mike","0":"mike"},{"name":"john","0":"john"},{"name":"tito","0":"tito"}]
But i want to get this:
{"name":[{"mike","john","tito"}]}
Which PDO fetch_style or what should i do in PHP to receive the string i want on jQuery?
Many thanks.