Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 07-13-2005, 05:25 PM
Lionel Lionel is offline
 
Join Date: Dec 2001
Location: Delray Beach, Florida
Posts: 3,277
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Querying multiple tables

Why would I get the same result over and over here for the below code (the magnifier image)? Looks like once it finds one it puts it in all the others afterwards. (In order to make this thread short, I removed the excess ... )Depending of the first query results, it determines which table to use in the second query.

Thanks in advance for any help.

PHP Code:
$get_matches $DB_site->query("blabla");
$i=0
while(
$data $DB_site->fetch_array($get_matches)) 
{
if(
$i == 0

$temp $data['date']; 

if(
$data['date'] <= $temp

$date $data['date'];
if(
$data['hometeam'] == "AAA"){
$thefolderhome "aaa";
$thedbhome "FROM asc_matches";
$thedbhomepic "FROM asc_picturegallery";
}
else if(
$data['hometeam'] == "BBB"){
$thefolderhome "bbb";
$thedbhome "FROM aiglenoir_matches";
$thedbhomepic "FROM aiglenoir_picturegallery";
}
 
//repeated 14 more times ....
 
if($data['awayteam'] == "AAA"){
 
$theteam "aaa";
 
$thefolderaway "asc";
 
$thedbaway "asc_opponents";
 
$thedbawaypic "FROM asc_picturegallery";
 
}
 
else if(
$data['awayteam'] == "BBB"){
$theteam "bbb";
$thefolderaway "aiglenoir";
$thedbaway "aiglenoir_opponents";
$thedbawaypic "FROM aiglenoir_picturegallery";
//repeated 14 more times ....
$getreport $DB_site->query("SELECT
blabla 
$thedbhome M, $thedbaway O 
WHERE M.MatchDateTime < CURRENT_TIMESTAMP AND M.MatchReport != '' AND
O.OpponentID = M.MatchOpponent 
"
);
while(
$hasreport $DB_site->fetch_array($getreport))
{
$reportid$hasreport['id'];
$thereport "<a href=\"football/$thefolderhome/matchdetails.php?id=$reportid\"><img src=\"/football/preview.gif\" alt=\"match report\" border=\"0\"></a>";
 
$havepics =$DB_site->query_first("SELECT count(PictureID) AS pic $thedbhomepic
WHERE PictureMatchID = 
$reportid");
if (
$havepics[pic] > 0)
{
$reportgallery "<a href=\"<A href="football/$thefolderhome/picturegallery.php?id=$reportid\"><img src=\"/haitianforums/football/camera.gif\" alt=\"Pictures from the match\" border=\"0\" align=\"right\"></a>";
}
else
{
$reportgallery '';
}
}
 
eval(
'$scoreboardbits .= "' fetch_template('soccerscoreboardbits') . '";');
}
else 

break; 

$i++; 

$DB_site->free_result($get_matches);
$DB_site->free_result(getreport); 
Reply With Quote
  #2  
Old 07-14-2005, 07:26 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Very difficult to anwer without the complete code and samples of the data, but i think the following query is the problem:
PHP Code:
            $getreport $DB_site->query("SELECT
                blabla 
$thedbhome M, $thedbaway O 
                WHERE M.MatchDateTime < CURRENT_TIMESTAMP AND M.MatchReport != '' AND
                O.OpponentID = M.MatchOpponent 
                "
); 
You are running this query inside a loop where you are processing all matches. In the above query you however don't select on the 'matchid' (or whatever that is called). The result is that you will get the reports of all matches, and you will be using the $reportid from the first match over and over.

PS Next time please use the [ php ] tags, makes it a lot easier to read.
Reply With Quote
Reply

Thread Tools
Display Modes

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 02:55 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.05515 seconds
  • Memory Usage 2,184KB
  • 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
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)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