PDO newbie question?

[altergothen]

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();

}

[monkeysaurus]

You can use a while loop instead; this is explained here.