vb.org Archive - simple query syntax question (ordering, displaying X latest)

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

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

- - simple query syntax question (ordering, displaying X latest) (https://vborg.vbsupport.ru/showthread.php?t=164466)

Mikhailtech

12-06-2007 01:45 AM

simple query syntax question (ordering, displaying X latest)

Hi,

I have this code:

PHP Code:


		
			
$xxx= $db->query_read("

    SELECT * FROM " . TABLE_PREFIX . "yyy

    ORDER BY postdate

");

I'm not very familiar with PHP (I'm just modifying an existing script). Right now this results in an output showing me all the table entries, the top being the earliest, the bottom being the latest. In other words, it would show:

1
2
3
4
5
6
7
8
9 (let's say 9 is the most recently posted entry)

I would like it to show only the 5 latest, with the top being the latest and bottom being the earliest of the 5. I want it to show:

9
8
7
6
5

Can anyone tell me what the syntax would be for this?

Mythotical

12-06-2007 01:51 AM

Use this:

PHP Code:


		
			
$xxx= $db->query_read("
    SELECT * FROM " . TABLE_PREFIX . "yyy
    ORDER BY postdate
    LIMIT 5
");

Mikhailtech

12-06-2007 03:49 AM

Does that reverse the order though?

Marco van Herwaarden

12-06-2007 06:05 AM

Use "ORDER BY postdate DESC"

Mikhailtech

12-06-2007 01:29 PM

Thank you so much, this is exactly what I was looking for :)

All times are GMT. The time now is 03:18 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01166 seconds Memory Usage 1,716KB 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 (2)bbcode_php_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
Messages: