On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • Quote from: Carsten at Jun 28, 2005, 06:11 PM

    ugh, no edit button.

    anyway, so ... you gonna show some stuff smiley smiley smiley

    I’m dieing to see at least an example smiley

    I understand smiley 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"));


      xWisdom
      www.xwisdomhtml.com
      The fear of the Lord is the beginning of wisdom:
      MODx Co-Founder - Create and do more with less.
    • cool smiley

      Can’t wait!
        Tangent-Warrior smiley