Re: newbie PDO query display question

On Sun, Jun 16, 2013 at 6:29 PM, dealTek <dealtek@gmail.com> wrote: > Hi all, > > newbie PDO question... > > I think (hard to tell - buried in a wrapper class) I am doing a select > query using - PDO::FETCH_ASSOC like... > > wrapper ------ return $pdostmt->fetchAll(PDO::FETCH_ASSOC); > > --- > > so my query is like... > > $results = $db->select("mytable", "id = 201"); //just 1 exact record) > > then I can loop like...... > foreach ($results as $result) { > .... > ?> > > <tr> > <td><?php echo $result["First"]; ?></td> > <td><?php echo $result["Last"]; ?></td> > <td><?php echo $result["id"]; ?></td> > > </tr> > > This all works fine..... > > ---> But since I only have 1 exact record - I don't need to LOOP anything > - so... > > Q: How do I display the columns without a loop > > > these fail - so what will work > > echo $results["First"]; > echo $results["First"][0]; ??? > echo $results["First"][1]; ??? > > > PDO::fetchAll returns its data as an array, even if only one record is returned. In this case, echo $results[0]["First"]; echo $results[0]["Last]; echo $results[0]["id"]; will do what you want. <snip>