Go Back   vb.org Archive > Search Forums
Reload this Page Search Results
FAQ Community Calendar Today's Posts Search

Showing results 1 to 3 of 3
Search took 0.01 seconds. Search: Posts Made By: kgroneman
Forum: vB4 General Discussions 08-31-2017, 10:52 PM
Replies: 6
Views: 537
Posted By Simon Lloyd
Try thisSELECT FROM_UNIXTIME(dateline),...

Try thisSELECT FROM_UNIXTIME(dateline), thread.postusername, thread.title AS threadtitle, forum.title AS forumtitle, forum.forumid
FROM vb_thread AS thread
INNER JOIN vb_forum AS forum on...
Forum: vB4 General Discussions 05-12-2016, 01:43 PM
Replies: 6
Views: 419
Posted By squidsk
When two tables have columns with the same name...

When two tables have columns with the same name and you want to refer to one of them you need to prefix it with the table name. In your case both thread and post have a dateline column so you'd need...
Forum: vB4 General Discussions 05-12-2016, 01:20 PM
Replies: 6
Views: 419
Posted By Dave
The post table does not contain a column called...

The post table does not contain a column called forumid, you'd have to LEFT JOIN the thread table.
So add LEFT JOIN vb_thread ON vb_thread.threadid = vb_post.threadid and change forumid to...
Showing results 1 to 3 of 3

 
Forum Jump

All times are GMT. The time now is 06:31 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01241 seconds
  • Memory Usage 1,895KB
  • 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)footer
  • (1)forumjump
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (2)navbar_link
  • (120)option
  • (1)post_thanks_navbar_search
  • (1)search_results
  • (3)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • inlinemod
  • prefix
  • search
Included Files:
  • ./search.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/functions_search.php
  • ./includes/functions_databuild.php
  • ./includes/functions_forumlist.php
  • ./includes/functions_misc.php
  • ./includes/functions_forumdisplay.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • search_before_process
  • search_start
  • search_results_start
  • search_results_query_posts
  • search_results_prebits
  • threadbit_process
  • search_results_postbit
  • forumjump
  • search_complete
  • navbits
  • navbits_complete