Often you just need one value or one row of values from a table. If your query returns a unique row because of the query or because you limited it to one row, then you don\u2019t need to go through the foreach loop to get the values. You can change the fetchAll() to fetch() and use just one line to get the value.
\n
\n\/\/ get the current category name\n$qry = "SELECT name FROM `website`.`book_category` ";\n$qry .= "WHERE id = :categoryID";\n\n$stmt = $dbWG->prepare($qry);\n$stmt->bindParam(':categoryID', $categoryID);\n$stmt->execute();\n\n$results = $stmt->fetch();\n$categoryName = $results['name'];<\/code><\/pre> <\/p>\n","protected":false},"excerpt":{"rendered":"Often you just need one value or one row of values from a table. If your query returns a unique row because of the query or because you limited it to one row, then you don\u2019t need to go through the foreach loop to get the values. You can change the fetchAll() to fetch() and … Continue reading Getting one row from a MySQL query<\/span><\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-2433","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts\/2433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2433"}],"version-history":[{"count":0,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts\/2433\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}