vb.org Archive - Combining 3 queries

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

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

- - Combining 3 queries (https://vborg.vbsupport.ru/showthread.php?t=55994)

Takara

08-08-2003 03:26 AM

Combining 3 queries

I have 3 queries that are pretty much the same, each one just gets the total amount of rows that match a certin criteria. But I'm wondering if there is a way to merge the 3 queries into 1, this is the code I'm using:

PHP Code:


		
			
$q="SELECT count(*) from tracker where viewed=0"; 

$result= mysql_db_query($dbase, $q, $connection) or die ("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result)) { $out = $row[0]; }



$q="SELECT count(*) from tracker where viewed=1 and status=0"; 

$result= mysql_db_query($dbase, $q, $connection) or die ("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result)) { $pen = $row[0]; }



$q="SELECT count(*) from tracker"; 

$result= mysql_db_query($dbase, $q, $connection) or die ("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result)) { $tot = $row[0]; }

Any help would be really appreciated. Thanks

g-force2k2

08-08-2003 05:08 AM

PHP Code:


		
			
$q = "SELECT COUNT(*) AS tot,

    SUM( IF( viewed=1 AND status=0,1,0 ) ) AS pen,

    SUM( IF( viewed=0,1,0 ) ) AS out

    FROM tracker" );

$result = mysql_db_query( $dbase, $q, $connection ) or die( "Could not execute query: $q." . mysql_error(  ) );

while( $row = mysql_fetch_array( $result ) )

{

  $tot = $row[tot];

  $out = $row[out];

  $pen = $row[pen];

}

Enjoy should work if not let me know...

regards,
g-force2k2

Takara

08-08-2003 10:50 AM

I'll let you know when I fix this new issue...

[warn] getsockname

*sigh*, tried re-installing but apache still hates me. Can't load any pages *shrug*.. just get that error. But thanks for your help.

g-force2k2

08-08-2003 03:14 PM

hmm... perhaps search for phptriad it auto installs apache and mysql and has worked for me...

sorry but i don't know much about apache configuration...

regards,
g-force2k2

Takara

08-09-2003 07:48 AM

It ended up that bootvis was making a log file that just kept growing :/ I had no diskspace left, and that was causing the problem. But other than that the ); following the actual query shouldn't have been there, it caused an error.
I removed it and it works great. Thanks alot for the help, I've taken a look at that code and gone ahead and applied it to my other queries.

All times are GMT. The time now is 02:36 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01141 seconds Memory Usage 1,729KB 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: