IS there an easier way to get a single result from a PDO query than having to run a foreach when I already know that there should only be a single record or value being returned?
I tried using $myresult = $dbh->exec($sql); ...but only returns a 1
$dbh = new PDO("$Driver1:host=$Server1;dbname=$db1", $User1, $Password1);
try {
$sql = "SELECT FileVersion FROM FileVersion WHERE GroupID = $GroupID ORDER BY FileVersion Desc";
foreach ($dbh->query($sql) as $myrow)
{
$FileVersion = $myrow['FileVersion'];
}
$dbh = null;
}
catch(PDOException $e)
{
echo $e->getMessage();
}