Jump to content

jon_we4

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

jon_we4's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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?
×
×
  • Create New...

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.