newbie PDO query display question

From: 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]

« previous php.general (#321415) next »