Food

You need a new dish in a hurry? Stumped by how to make that something special? We can help with your busy lifestyle. Take a look around and review our hundreds of free recipes or submit one of your own favorites by clicking here: Submit Recipe


By Cuisine   Latest  
function getNodeCount($tid)
{
$sql = "select count(1) as num"
. " from term_node"
. " where tid = $tid";
return ($acount = db_fetch_object(db_query($sql)))? $acount->num : 0;
}

function getChildTerms($parent, $vid)
{
$sql = “select td.tid, td.vid, td.name”
. ” from term_data td”
. ” join term_hierarchy th on th.tid = td.tid”
. ” where th.parent = $parent”
. ” and td.vid = $vid”
. ” order by td.weight, td.name”;
$terms = db_query($sql);
$output = “”;
while ($aterm = db_fetch_object($terms))
{
$output .= “

  • tid’>$aterm->name (”
    . getNodeCount($aterm->tid).”)

    • \n”
    . getChildTerms($aterm->tid, $vid);
    }
    return ($output != “”)? “

      \n” . $output . “

    \n” : “”;
    }

    $sql = “select vid, name from vocabulary where name in (‘recipe type’, ‘cuisines’) order by name”;
    $vocabularies = db_query($sql);
    $output = “”;
    while ($avoc = db_fetch_object($vocabularies))
    {
    $output .= “

  • $avoc->name

    • \n”
    . getChildTerms(0, $avoc->vid);
    }
    print “

      \n” . $output . “

    \n”;

    ?>

    		 $mlist="15";
    $moutput4 = node_title_list(db_query_range(db_rewrite_sql("SELECT n.nid, n.title, n.created FROM {node} n WHERE n.type = 'flexinode-9' AND n.status = 1 ORDER BY n.created DESC"), 0, $mlist));
    print $moutput4;
    ?>