<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=PL link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Is that the complete
snippet?</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>//----------------------------------------------------------------------------</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>$nresult = mysql_query('SELECT n.nid, n.body, n.type,
n.title,<br>
n.promote, n.moderate, n.teaser, n.created , n.changed, </span><a
href="http://u.name/" target="_blank"><span lang=EN-US>u.name</span></a></font><span
lang=EN-US> FROM<br>
node n , users u,term_node tn, users_roles ur where n.uid = u.uid<br>
AND n.nid=tn.nid AND u.uid=ur.uid AND n.status = 1 AND n.created ><br>
$period ORDER BY n.created');<br>
<br>
$nodes = array();<br>
<br>
while ($row = mysql_fetch_array($nresult, MYSQL_NUM))<br>
{<br>
$nodes[$node->nid] = $node;<br>
<br>
}</span></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>//--------------------------------------------------------------------------------------------------------------------</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>If so in the while
statement : </span></font><span lang=EN-US> $nodes[$node->nid] = $node;
has no sense because you are receiving an assoc array and keep it in $row array
which has no connection to $nodes[$node->nid]=$node;</span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>What is $node??? What is $node->nid the only thing
which contains any data is $nresult and $row so check what your variables
contain.</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>Mac</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>maciej.perlinski@meant4.com</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
VJ Rao [mailto:cmsconsultant@gmail.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, September 13,
2006 7:33 PM<br>
<b><span style='font-weight:bold'>To:</span></b> development@drupal.org;
support@drupal.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> [development] programming
question (drupal specific)</span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Whats the difference between these two code snippets (1 works, 2
doesnt) :<br>
<br>
1)<br>
<br>
$nresult = db_query('SELECT n.nid, n.body, n.type, n.title, n.promote,<br>
n.moderate, n.teaser, n.created, n.changed, <a href="http://u.name/"
target="_blank">u.name</a> FROM {node} n ,<br>
{users} u, {term_node} tn, {users_roles} ur where n.uid = u.uid AND<br>
n.nid=tn.nid AND u.uid=ur.uid AND n.status = 1 AND n.created > %d<br>
ORDER BY n.created', $period);<br>
<br>
$nodes = array(); <br>
<br>
while ($node = db_fetch_object($nresult)) {<br>
$nodes[$node->nid] = $node;<br>
}<br>
<br>
2)<br>
<br>
$nresult = mysql_query('SELECT n.nid, n.body, n.type, n.title,<br>
n.promote, n.moderate, n.teaser, n.created , n.changed, <a href="http://u.name/"
target="_blank">u.name</a> FROM<br>
node n , users u,term_node tn, users_roles ur where n.uid = u.uid<br>
AND n.nid=tn.nid AND u.uid=ur.uid AND n.status = 1 AND n.created ><br>
$period ORDER BY n.created');<br>
<br>
$nodes = array();<br>
<br>
while ($row = mysql_fetch_array($nresult, MYSQL_NUM))<br>
{<br>
$nodes[$node->nid] = $node;<br>
<br>
}</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Regads,</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>V</span></font></p>
</div>
</div>
</body>
</html>