troubles with mdb2's numRows() function

[Milan Krejci]

function odstran($jmeno) {
$this->res=&$this->mdb2->query("DELETE FROM auth WHERE
username='".$jmeno."' LIMIT 1");
if (PEAR::isError($this->res)) die($this->res->getMessage());
//var_dump($this->res);
//echo $this->res->numRows();
//if ($this->res->numRows()==1) echo ('<p>Uzivatel odstranen</p>');
////////////////////BUG ^^^
}

it should return 0 or 1 but it is NULL. the record has been deleted
allright but numRows() doesn't return anything even if nothing has been
deleted.

[petersprc]

Wonder what happens if you do:

$db->loadModule('Extended');
$count = $db->extended->execParam('delete from auth where username = ?
limit 1', array('.$|meno.'), null);

echo "Delete $count records.";

On Jul 26, 7:31 am, Milan Krejci <[e-mail]:

function odstran($jmeno) {
$this->res=&$this->mdb2->query("DELETE FROM auth WHERE
username='".$jmeno."' LIMIT 1");
if (PEAR::isError($this->res)) die($this->res->getMessage());
//var_dump($this->res);
//echo $this->res->numRows();
//if ($this->res->numRows()==1) echo ('<p>Uzivatel odstranen</p>');
////////////////////BUG ^^^
}

it should return 0 or 1 but it is NULL. the record has been deleted
allright but numRows() doesn't return anything even if nothing has been
deleted.

[Milan Krejci]

thanks mate! now it works, only
array('.$|meno.')
should be array($jmeno)
petersprc napsal(a):

Wonder what happens if you do:

$db->loadModule('Extended');
$count = $db->extended->execParam('delete from auth where username = ?
limit 1', array('.$|meno.'), null);

echo "Delete $count records.";

On Jul 26, 7:31 am, Milan Krejci <[e-mail]:

>function odstran($jmeno) {
$this->res=&$this->mdb2->query("DELETE FROM auth WHERE
username='".$jmeno."' LIMIT 1");
if (PEAR::isError($this->res)) die($this->res->getMessage());
//var_dump($this->res);
//echo $this->res->numRows();
//if ($this->res->numRows()==1) echo ('<p>Uzivatel odstranen</p>');
////////////////////BUG ^^^
}

it should return 0 or 1 but it is NULL. the record has been deleted
allright but numRows() doesn't return anything even if nothing has been
deleted.