MDB2 and User-Define MySQL Variables

[soladon13]

Hello,

I really need some help here.

I am running the following:

<?php
require_once('MDB2.php');

$dsn = 'mysqli://username:password@localhost/';

$db =& MDB2::singleton($dsn);

$prep =& $db->prepare('SELECT @x:=5');
$res = $prep->execute();

if (MDB2::isError($res)) {
echo "Error.\n";
echo $res->message . "\n";
echo $res->userinfo . "\n";
}

?>


but I am getting the following error:
"Error. MDB2 Error: not found [Error message: Unable to bind to missing placeholder: SELECT @x:=5] "

Is there another way to set a variable?
Any ideas for a fix?

Thank you

[mark]

The ":" conflicts with prepare, see here:
http://pear.php.net/manual/en/package.database.mdb2.intro-execute.php

If you use just query(), it should work:
http://pear.php.net/manual/en/package.database.mdb2.intro-query.php

[soladon13]