Iwas wondering if someone could help me?
I have a table called markers, in this table it stores multiple records each with a name etc. I would like to echo each name however the below code only shows one results. How can I show more than one. Can someone please help I am new to PDO.
$stmt = $dtb->query('SELECT * FROM markers'); while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $markerName = $row['name']; } Use an array to hold the result, in your code, the variable $markerName is overwrote on each iteration.
$stmt = $dtb->query('SELECT * FROM markers'); $markerName = array(); while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $markerName[] = $row['name']; } That is because you are overwriting it each and every time , use an array instead.
$markerName = array(); //<---- Add here while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $markerName[] = $row['name']; } echo implode('<br>',$markerName); //<---- Implode it up for display 
$names = $dtb->query('SELECT * FROM markers')->fetchAll(); Being new to PDO, you are supposed to try tag wiki first, where you can find an answer not only to this one but to many other questions.
