The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
PHP Nesting?
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(); Can anyone get me a step into the right direction? |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|