newbie PDO query display question
| From: | dealTek | Date: | Sun, 16 Jun 2013 22:29:41 +0000 |
| Subject: | newbie PDO query display question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-321415@lists.php.net to get a copy of this message | ||
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]; ???
--
Thanks,
Dave
rev@musenet.com
[db-3]
--
Thanks,
Dave - DealTek
dealtek@gmail.com
[db-3]