CodingForums.com - View Single Post

Fou-Lu · 12-31-2012, 07:41 PM

The value, as in country?

PHP Code:


			
if ($stmt = $pdo->prepare('SELECT count(*) FROM test WHERE Country = :country'))
{
    $stmt->execute(array(':country' => $_GET['Country']));
    $count = $stmt->fetchAll();
}

Unless you mean dynamic userchosen as the properties to fetch, then the answer is no you cannot use binding for that (you cannot create a dynamic structure on a prepared statement).

12-31-2012, 07:41 PM	PM User \| #2
Fou-Lu God Emperor Join Date: Sep 2002 Location: Saskatoon, Saskatchewan Posts: 15,662 Thanks: 4 Thanked 2,452 Times in 2,421 Posts	The value, as in country? PHP Code: `if ($stmt = $pdo->prepare('SELECT count(*) FROM test WHERE Country = :country')) { $stmt->execute(array(':country' => $_GET['Country'])); $count = $stmt->fetchAll(); }` Unless you mean dynamic userchosen as the properties to fetch, then the answer is no you cannot use binding for that (you cannot create a dynamic structure on a prepared statement).