vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Querying multiple tables (https://vborg.vbsupport.ru/showthread.php?t=92119)

Lionel 07-13-2005 05:25 PM
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); 

Marco van Herwaarden 07-14-2005 07:26 AM
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.


All times are GMT. The time now is 01:12 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01058 seconds
  • Memory Usage 1,739KB
  • 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
  • (2)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