dealTek <dealtek@xxxxxxxxx> wrote:
>
>On Jun 16, 2013, at 3:37 PM, Stephen <stephen-d@xxxxxxxxxx> wrote:
>
>> Here is a sample from my code:
>>
>> $photo_category_list = "";
>> $SQL = "SELECT category_id, category_name FROM gallery_category
>ORDER by category_order";
>> try {
>> $stmt = $dbh->prepare($SQL);
>> $stmt->execute();
>> while ( list( $id, $name) = $stmt->fetch(PDO::FETCH_NUM)) {
>> $photo_category_list .= "<option
>value=$id>$name</option>\n";
>> }
>> }
>> catch (PDOException $e){
>> echo 'Error getting category name. ' . $e->getMessage();
>> }
>> return $photo_category_list;
>>
>> Try to avoid your code assuming that you will just get one record
>back (unless you use Limit 1)
>>
>
>
>Thanks Stephen,
>
>Nice code!
>
>you mentioned ... - to avoid your code assuming that you will just get
>one record back
>
>But what about the case where you are deliberately just showing one
>record as in ---- FIND ONE PERSON like---- where ID = 101 ?
>
>do you still need to loop through when you just selected/displayed 1
>ITEM?
>
>Q: How do I display the columns without a loop in this 1 record
>case...?
>
>
>these fail - so what will work?
>
>echo $results["First"];
>echo $results["First"][0]; ???
>echo $results["First"][1]; ???
>
>
>
>> While works better than foreach for getting the result rows from PDO
>
>
>
>
>
>
>
>
>--
>Thanks,
>Dave - DealTek
>dealtek@xxxxxxxxx
>[db-3]
Have you tried chaining the the fetch() method on as in:
$pdo_object->query()->fetch();
Thanks,
Ash
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
