Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-08-2003, 03:26 AM
Takara's Avatar
Takara Takara is offline
 
Join Date: Apr 2002
Location: :bunny:
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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"
$resultmysql_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"
$resultmysql_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"
$resultmysql_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
Reply With Quote
  #2  
Old 08-08-2003, 05:08 AM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #3  
Old 08-08-2003, 10:50 AM
Takara's Avatar
Takara Takara is offline
 
Join Date: Apr 2002
Location: :bunny:
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 08-08-2003, 03:14 PM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #5  
Old 08-09-2003, 07:48 AM
Takara's Avatar
Takara Takara is offline
 
Join Date: Apr 2002
Location: :bunny:
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:44 PM.


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.03967 seconds
  • Memory Usage 2,205KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete