vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   SQL "ORDER BY" question (https://vborg.vbsupport.ru/showthread.php?t=82214)

Cloudrunner 05-29-2005 08:27 PM
SQL "ORDER BY" question
 
One more folks ;)

PHP Code:
"SELECT * FROM ".TABLE_PREFIX."table ORDER BY total DESC LIMIT 0,5"; 
Given that statement, if I have data in the totals column that equals 9687, and data that has 987 in the totals column, it outputs that the number 987 is bigger (thus comes first) than 9687. How do I make it do real counting in the SQL statement (i.e. 9687 is bigger than 987 thus 9687 is displayed first).

Thanks!

)O( Cloudrunner )O(

Paul M 05-29-2005 08:48 PM
The only way that I can see 987 would come out bigger than 9687 is if it's a text field, not a numeric field, in which case you should fix the basic problem of the field type (for 'total') being wrong.

Cloudrunner 05-29-2005 09:50 PM
Quote:
Originally Posted by Paul M
The only way that I can see 987 would come out bigger than 9687 is if it's a text field, not a numeric field, in which case you should fix the basic problem of the field type (for 'total') being wrong.
Well duh...

Thank you Paul! Fixed the problem right off.

Paul M 05-30-2005 09:06 AM
Good. :)


All times are GMT. The time now is 03:05 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.01876 seconds
  • Memory Usage 1,713KB
  • 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
  • (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
  • (4)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