vb.org Archive - Last xx posts, can you correct my code pls.

Page 2 of 2

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

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

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

- - Last xx posts, can you correct my code pls. (https://vborg.vbsupport.ru/showthread.php?t=108971)

Xenon

03-07-2006 05:46 PM

nope, that is not possible and will produce an error

FFMG	03-07-2006 05:52 PM

Quote:

Originally Posted by Xenon

nope, that is not possible and will produce an error

Well, it is working for me http://www.httppoint.com/seo_tool_pr.php

And I have tried with phpMyAdmin and it works as well.

What do you mean by it would cause an error?

FFMG

Xenon

03-07-2006 07:21 PM

hmm, mysql is a bit lazy when handling grouping queries, normaly according to the sql standart that query should produce an errormessage as it's not possible to tell which information of which post should be selected

if it works, then ok, but that can change with new versions of mysql, that's why i wouldn't code it that way.

PyroNET

03-14-2006 12:32 AM

Code:

$posts = $db->query_read("SELECT * FROM post INNER JOIN thread USING(threadid) ORDER BY post.dateline DESC LIMIT 3");



while ($posts = $db->fetch_array($posts)) {



echo $posts['title'];



}

Why does this query return one result when there should be many more?

All times are GMT. The time now is 11:49 PM.

Page 2 of 2

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

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