wwwroot/inc/eventz/get_templates.inc

   1 <?php
   2 function get_templates() {
   3 $sql = "select * from `nodes` where `external_link` LIKE 'template://%'";
   4 $q = mysql_query($sql);
   5 if(mysql_num_rows($q)) {
   6 $count = mysql_num_rows($q);
   7
   8 while($res = mysql_fetch_object($q)) {
   9         $content = mysql_fetch_object(mysql_query("select * from `node_content` where `node_id` = '{$res->node_id}'"));
  10         print $res->node_id;
  11         print ">>>";
  12         print $content->node_content;
  13         print "<br>";
  14 }
  15 }
  16 }
  17
  18 ?>