Re: [PHP] newbie PDO query display question

>> >> > When you know there is only one row to be returned you can do this: > > $photo_category_list = ""; > $SQL = "SELECT category_id, category_name FROM gallery_category ORDER by > category_order"; > try { > $stmt = $dbh->prepare($SQL); > $stmt->execute(); > list( $id,

Re: [PHP] newbie PDO query display question

dealTek wrote: > >On Jun 16, 2013, at 3:37 PM, Stephen 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); >>$stm

Re: [PHP] newbie PDO query display question

On Jun 16, 2013, at 3:37 PM, Stephen 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(); >whil

Re: [PHP] LightBox click detection

On Fri, Jun 14, 2013 at 8:52 AM, Tedd Sperling wrote: > Here's the problem -- I need to count the number of times a user activates a > LightBox -- how do you do that? If you're using Google Analytics, you can use click tracking:

[PHP] newbie PDO query display question

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 r