Quote from: Carsten at Jun 28, 2005, 06:11 PM
ugh, no edit button.
anyway, so ... you gonna show some stuff
I’m dieing to see at least an example
I understand
I’ll post the DBAPI extension here when I’ve completed some other test on it. It’s currently undergoing some tests inside the manager but from what I’ve seen I can say that it makes life much easier.
example:
Go from:
$sql = "SELECT pagetitle FROM $dbase.".$table_prefix."site_content";
$rs = mysql_query($sql);
while($row=mysql_fetch_assoc($rs)) echo $row["pagetitle"]."
";
to:
$ds = $modx->db->select("pagetitle",$modx->getFullTableName("site_content"));
echo implode("
",$modx->db->getColumn("pagetitle",$ds));
or even:
echo implode("
",$modx->db->getColumn("pagetitle","SELECT pagetitle FROM $dbase.".$table_prefix."site_content"));