PDO Echoing Column

[radioactive]

I want to echo the contents of column 4 for my username only, and it doesn't show anything. I can do if ($memberQuery->fetchColumn(4) < 2) though.

 

$host = 'localhost';
$database = '';
$db_username = '';
$db_password = '';

if (($db = new PDO("mysql:host=$host;dbname=$database", $db_username, $db_password)) == NULL) {
echo $db->getMessage();
}

$memberQuery = $db->prepare("SELECT * FROM members WHERE username=:username");
$memberQuery->execute(array(':username' => $_SESSION['username']));
$result = $memberQuery->fetchColumn(4);
echo "$result";

[xyph]

Why not just

 

SELECT nameof5thcolumn FROM table WHERE username=:username

 

And then fetchColumn(0) ?

 

Works fine for me.

[radioactive]

This is my changed code, but nothing is echoing still.

 

$memberQuery = $db->prepare("SELECT expiry FROM members WHERE username=:username");
$memberQuery->execute(array(':username' => $_SESSION['username']));
$result = $memberQuery->fetchColumn(0);
echo "$result";

[xyph]

Perhaps allowing PDO to report errors?

 

$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

 

This must be before you execute your query though.

[radioactive]

Nope, it does not echo anything

[radioactive]

I figured out my problem, I had forgotten to use session_start

[xyph]

To avoid this in the future, please ensure your scripts are reporting all possible errors. A snippet to do this can be found in my signature.

 

This will tell you if you try to use a variable/key that hasn't been declared.