programming question (drupal specific)
Whats the difference between these two code snippets (1 works, 2 doesnt) : 1) $nresult = db_query('SELECT n.nid, n.body, n.type, n.title, n.promote, n.moderate, n.teaser, n.created, n.changed, u.name FROM {node} n , {users} u, {term_node} tn, {users_roles} ur where n.uid = u.uid AND n.nid=tn.nid AND u.uid=ur.uid AND n.status = 1 AND n.created > %d ORDER BY n.created', $period); $nodes = array(); while ($node = db_fetch_object($nresult)) { $nodes[$node->nid] = $node; } 2) $nresult = mysql_query('SELECT n.nid, n.body, n.type, n.title, n.promote, n.moderate, n.teaser, n.created, n.changed, u.name FROM node n , users u,term_node tn, users_roles ur where n.uid = u.uid AND n.nid=tn.nid AND u.uid=ur.uid AND n.status = 1 AND n.created > $period ORDER BY n.created'); $nodes = array(); while ($row = mysql_fetch_array($nresult, MYSQL_NUM)) { $nodes[$node->nid] = $node; } Regads, V
participants (1)
-
VJ Rao