Jump to content

Archived

This topic is now archived and is closed to further replies.

jon_we4

PHP Nesting?

Recommended Posts

I am not the most fluent with PHP but I am with other languages ...

What I am trying to do is one query and list out the info, but for each listing it needs its own query. I may be going about it the wrong way (well obviously since its not working).

[code]function getlist()
{
         global $db;

         $list1 = $db->query_read("
                 SELECT          *
                 FROM            top_list
                 ORDER BY       id
                 ");

          if ($db->num_rows($classlist) == 0)
                  return NULL;

        while($list1row = $db->fetch_array($list1)) {
            
       $list2 = $db->query_read("

                 SELECT          *
                 FROM            top_list_info
                 WHERE listid = $list1row[id]
                 ORDER BY        id
                 ");    

  $retStr .= "

  <tr>
<td class=\"tcat\" colspan=\"6\"><b>$classrow[class_name]</b></td>
</tr>
  <tr>  
  <tr>
<td class=\"alt1\" colspan=\"6\">$classrow[class_desc]</td>
</tr>
     <tr>                              
<td class=\"alt2\" width=\"10%\"><div class=\"smallfont\"><b>Username</b></div></td><td class=\"alt2\"><div class=\"smallfont\"><b>option1</b></div></td><td class=\"alt2\"><div class=\"smallfont\"><b>option2</b></div></td><td class=\"alt2\"><div class=\"smallfont\"><b>option3</b></div></td><td class=\"alt2\" ><div class=\"smallfont\"><b>option4</b></div></td><td class=\"alt2\" width=\"45%\"><div class=\"smallfont\"><b>Notes</b></div></td>
</tr>    


";

    }

         return "$retStr";
    
}

$timelist = getlist();[/code]


This functions fine, but I wanted to add another "while" loop thru the second query but it doesnt like nesting it.

Can anyone get me a step into the right direction?

Share this post


Link to post
Share on other sites
Surely this is a job for an sql JOIN? Recursive database queries are VERY inificient.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.