The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
Using vb to pull information from the database.
Ohh Lynne ohh Lynne where could you be I need help with my PHP. LMAO
I am trying to pull information from the database using vBulletin's existing structure. My only problem is it only pulls one result. Code:
// ###### Check query returns result ##### $result = $db->query(" SELECT * FROM " . TABLE_PREFIX . "glossary WHERE LEFT(word,1)='$letter' ORDER BY word "); // ##### Check if empty result ##### if (empty($result)) { $dataresult = "1"; } else { $dataresult = "2"; } // ##### Display by-letter ##### while ($row = $db->fetch_array($result,MYSQL_NUM)) { $result .= "<tr><td class=\"dbtext\"><b>$row[1]</b></td><td class=\"dbtext\">$row[2]</td></tr>"; } I am using this to pull it in the template. Code:
{vb:raw result} Sorry for all the questions and thanks for any help. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|