vb.org Archive - SQL Query Acting Weird

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

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

- - SQL Query Acting Weird (https://vborg.vbsupport.ru/showthread.php?t=166886)

ZomgStuff

01-04-2008 12:42 AM

SQL Query Acting Weird

https://vborg.vbsupport.ru/external/2008/01/48.jpg

It is weird, because I can call $username342342342342 just fine from a template, but if I change

Code:

$userinfo31221213 = fetch_userinfo($Entries['Date']);

Code:

$userinfo31221213 = fetch_userinfo($Entries['Author']);

It won't display? Why does it do this? I don't want to put my author column last.

Adrian Schneider

01-04-2008 12:49 AM

You should really perform a LEFT JOIN on the user table instead of a nested fetch_userinfo() call.

Why would you use $Entries['Date'] ... shouldn't it be $Entries['Author']. Also, I'm surprised your query even executes because 'Date' is a reserved MySQL keyword.

Add this debug code to the end of your loop

PHP Code:


		
			
var_dump($Entries);
var_dump($username342342342342); exit;

Finally, can you explain your logic behind it all? It's a bit confusing to me.

ZomgStuff

01-04-2008 12:52 AM

Quote:

Originally Posted by SirAdrian (Post 1415031)

PHP Code:


		
			
var_dump($Entries);

var_dump($username342342342342); exit;

Finally, can you explain your logic behind it all? It's a bit confusing to me.

It should be Author, but for some reason it would only work if it was the last column in the table.

How do I do a LEFT JOIN?

Guest190829

01-04-2008 07:54 AM

[sql] SELECT contestv.ID, contestv.Contest, contestv.Author, contestv.Location, contestv.Date, user.*
FROM " . TABLE_PREFIX ."contestview AS contestv
LEFT JOIN " . TABLE_PREFIX ."user AS user ON(user.username = contestv.Author)
WHERE contestv.ID = " . intval($contestID) . "
[/sql]

That is the gist of a LEFT JOIN...

Some other things: You should really use userid if you are currently using username...it is easier to index and better for normalization.

And column name are simpler to remember if all are lowercase IMO.

ZomgStuff

01-04-2008 12:39 PM

Ah, thank you.

ZomgStuff

01-07-2008 12:40 AM

Hm, I don't get it...

Code:

$queryMe = "SELECT contestv.ID, contestv.Contest, contestv.Author, contestv.Location, contestv.TheDate, user.*

        FROM " . TABLE_PREFIX . "contestview AS contestv

        LEFT JOIN " . TABLE_PREFIX . TABLE_PREFIX . "user AS user ON(user.username = contestv.Author)

        WHERE contestv.Contest = " . intval($contestID);

$Entry = $db->query_read($queryMe);

while ($Entries = $db->fetch_array($Entry) )

{

        eval('$contestEntries .= "' . fetch_template('contestview_bit') . '";');

}

https://vborg.vbsupport.ru/misc.php?do=bbcode
It freezes my internet browser.

Also Author is a userid.

Guest190829

01-08-2008 12:36 PM

You are concatenating TABLE_PREFIX twice to the user table, and if Author is a userid, you need to join on user.userid not user.username

All times are GMT. The time now is 05:52 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01097 seconds Memory Usage 1,731KB 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 (3)bbcode_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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: