Re: [PHP] newbie PDO query display question

dealTek <[email protected]> wrote:

>
>On Jun 16, 2013, at 3:37 PM, Stephen <[email protected]> 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
>[email protected]
>[db-3]

Have you tried chaining the the fetch() method on as in:

$pdo_object->query()->fetch();
Thanks,
Ash