Snippet to list data from MySQL database

// Connect to the database
$myusadb= new DBAPI();
$myusadb->connect($host='localhost',$dbase=''####', $uid=''####',$pwd='####');

// Get all the data from the content table
$result = mysql_query("SELECT * FROM `modx_site_content` WHERE `parent` = 7 ORDER BY pub_date DESC LIMIT 3") // put it into an array
or die(mysql_error());  
                echo "<ul>"; 
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {

                // Print out the contents of each row into a table
                echo "<li>"; 
                echo " <a href=\""; 
                echo $row['content'];
                echo "\" target=\"_blank\">"; 
                echo $row['description'];
                echo "</i> - "; 
                echo $row['pagetitle']; 
                echo "</a>"; 
                echo "</li>"; 
}
                echo "</ul>";
$myusadb->disconnect();

<ul>
[[getResources? 
&parents=`7` 
&includeContent=`1`
&sortby=`pub_date` 
&sortdir=`DESC` 
&limit=`3`
&tpl=`@INLINE <li> <a href="[[+content]]" target="_blank"> [[+description]]</i> - [[+pagetitle]]</a></li>  `
]]
</ul>

echo $results->get('content');