vb.org Archive - Help needed on first try at Database Query!

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Help needed on first try at Database Query! (https://vborg.vbsupport.ru/showthread.php?t=72983)

Dean C

12-28-2004 10:24 PM

You'll need to put something like this in your PHP file:

PHP Code:


		
			
$result_allweight['weight'] = vb_number_format($result_allweight['weight']);

EvilCrow

12-28-2004 11:04 PM

Quote:

Originally Posted by Dean C

You'll need to put something like this in your PHP file:

PHP Code:


		
			
$result_allweight['weight'] = vb_number_format($result_allweight['weight']);

Little confused what you mean. :ermm:

Dean C

12-29-2004 08:48 AM

Change this:

PHP Code:


		
			
// ### START TEST WEIGHT COUNT ##########################################

$result_allweight = $DB_site->query_first("

    SELECT COUNT(*) AS users,

    SUM(field7) AS weight

    FROM " . TABLE_PREFIX . "userfield

");

// ### END TEST WEIGHT COUNT#############################################

To this:

PHP Code:


		
			
// ### START TEST WEIGHT COUNT ##########################################

$result_allweight = $DB_site->query_first("

    SELECT COUNT(*) AS users,

    SUM(field7) AS weight

    FROM " . TABLE_PREFIX . "userfield

");

$result_allweight['weight'] = vb_number_format($result_allweight['weight']); 

// ### END TEST WEIGHT COUNT#############################################

EvilCrow

12-30-2004 05:14 AM

WOOHOO... Thank you very much!!!! :up: :classic: ;) :)

Dean C

12-30-2004 11:34 AM

You're welcome :)

Davey

01-17-2005 03:09 PM

Sorry I killed my hard drive, I haven't checked back here for a long time.
No problem, I got your pm, check the reply.
Happy to help.

All times are GMT. The time now is 07:59 AM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01032 seconds Memory Usage 1,735KB 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_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (6)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: