vb.org Archive - Help combinding 2 mysql queries

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

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

- - Help combinding 2 mysql queries (https://vborg.vbsupport.ru/showthread.php?t=109002)

rootnik

02-27-2006 03:20 AM

Help combinding 2 mysql queries

The first query is the most important one. I'm only using the 2nd query to get a count...

PHP Code:


		
			
SELECT u.username, u.lastactivity, f.field5, f.field14, f.field15, f.field16, f.field17, f.field19, f.userid

FROM user u

INNER JOIN userfield f

ON u.userid=f.userid

WHERE f.field16 = 'Yes' AND f.field19 > 0

ORDER BY u.lastactivity DESC;

Now I want to get a count of all members who has field19 set as greater than 0. It does not what the value of field16 is in the query below:

PHP Code:


		
			
$ingame = mysql_result($TheTopQuery, 0, 7);

$custom = $db->query_read("

SELECT field19 FROM userfield

WHERE userfield.field19 = $ingame

ORDER BY userid DESC;

        ");

Andrew

02-27-2006 12:26 PM

I think you need to move the variable $ingame from the second query out of the double quotes like so:

PHP Code:


		
			
$ingame = mysql_result($TheTopQuery, 0, 7);

$custom = $db->query_read("

    SELECT field19

    FROM userfield

    WHERE userfield.field19 = " . $ingame . "

    ORDER BY userid DESC

");

rootnik

02-27-2006 12:49 PM

Quote:

Originally Posted by Andrew

I think you need to move the variable $ingame from the second query out of the double quotes like so:

PHP Code:


		
			
$ingame = mysql_result($TheTopQuery, 0, 7);

$custom = $db->query_read("

    SELECT field19

    FROM userfield

    WHERE userfield.field19 = " . $ingame . "

    ORDER BY userid DESC

");

Thanks... but somehow the query works as needed without the double quotes.

Both queries work, I am just looking to combind then into 1 query.

Is it even possible considering that the value for $ingame comes from the first query?

Xenon

02-27-2006 02:47 PM

first of all
the doublequoete are irrelevant in that context

second: i don't really get the sense of the second query, you say you want to count member with the same valuie of field 19, but there is no count function in the query, so?

are you running the second query within a loop or what?
because soley combining a normal and a count query isn't possible, but if you tell us a bit more, maybe an optimization would be possible

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00997 seconds Memory Usage 1,733KB 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 (4)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
Messages: