vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Array Help (https://vborg.vbsupport.ru/showthread.php?t=274745)

evilthoutz 11-28-2011 04:26 AM
Array Help
 
Hello I am trying to create an array to list the results that it finds from the MySQL DB using the SELECT command.

Here is my code basically, im new to vBulletin + PHP.

Code:
$theuserid = $vbulletin->userinfo['userid'];
$result = $vbulletin->db ->query_read("SELECT * FROM vsa_advreg_invite WHERE inviter='$theuserid'");
while($row = $vbulletin->db->fetch_array){
$getcode =  "You invited: " . $row['invited']. "<br> Your Code to Give: ". $row['code'] . "<br>";
}

kh99 11-28-2011 05:18 AM
I think you're close, you just need the while line to be

Code:
while($row = $vbulletin->db->fetch_array($result)){

evilthoutz 11-28-2011 06:04 AM
I gave that a shot as well but still no luck. With that code it came out to be like

Code:
$theuserid = $vbulletin->userinfo['userid'];
$result = $vbulletin->db ->query_read("SELECT * FROM vsa_advreg_invite WHERE inviter='$theuserid'");
while($row = $vbulletin->db->fetch_array($result))
 {
 $getcode =  "You invited: " . $row['invited']. "<br> Your Code to Give: ". $row['code'] . "<br>";
 }
Still only showing the first result :\ I'm scratchin my head lol

Dead Eddie 11-28-2011 11:16 AM
Quote:
Originally Posted by evilthoutz (Post 2272641)
I gave that a shot as well but still no luck. With that code it came out to be like

Code:
$theuserid = $vbulletin->userinfo['userid'];
$result = $vbulletin->db ->query_read("SELECT * FROM vsa_advreg_invite WHERE inviter='$theuserid'");
while($row = $vbulletin->db->fetch_array($result))
 {
 $getcode =  "You invited: " . $row['invited']. "<br> Your Code to Give: ". $row['code'] . "<br>";
 }
Still only showing the first result :\ I'm scratchin my head lol
There's no way your code is going to return more than one result. Each time through the loop, you reassign the value to the same variable, deleting whatever used to be there. So, $getcode is only going to be equal to the last value it had when the loop ran.

Try this:
PHP Code:
$getcode = '';
$theuserid = $vbulletin->userinfo['userid'];
$result = $vbulletin->db ->query_read("SELECT * FROM vsa_advreg_invite WHERE inviter='$theuserid'");
while($row = $vbulletin->db->fetch_array($result))
 {
 $getcode .=  "You invited: " . $row['invited']. "<br> Your Code to Give: ". $row['code'] . "<br>";
 } 
(note the concatenation within the loop)

evilthoutz 11-28-2011 02:00 PM
That fixed it Dead Eddie! Makes since now as to what you said ^_^ Thanks a lot!!


All times are GMT. The time now is 02:43 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00938 seconds
  • Memory Usage 1,729KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete