[RESOLVED] query help

msnhockey

this query does somewhat what it is supposed to do.. the only problem I have is that the $sid is not working properly... its supposed to grab games played against in the current season and this takes all games played upto a max of 10

where is $sid is I changed to the current season id and nothing changes.
is there something i can change or something to get this to work.

thanks

	$result_ss3 = mysql_query("SELECT * FROM schedule_scores WHERE "
	."(team1 = $team1 AND team2 = $team2) OR (team1 = $team2 AND team2 = $team1)  "
	."AND season = ".$sid." "
        ."AND team1_score > '-' "
        ."AND team2_score > '-' "
	."ORDER BY date DESC LIMIT 10");

bradgrafelman

Is MySQL returning an error message (or did you even check to see if it was)? If so, what is it?

Have you tried removing the two team1_score conditionals? I'm not 100% sure, but to me > '-' doesn't look valid to me.

msnhockey

no errors at all with this part of the code.. it just displays a max of 10 previous games played... except
i get a syntax error on line 163, but nothing is on that line.
removing the > '-' puts games that haven't been played into the query

BlueKai

what kind of error? if the line before that is the query, sounds like the query is failing. echo it and copy/paste that directly into the db (phpmyadmin or whatever you use)

$res = "select whatever from wherever";
$result_ss3 = mysql_query($res);
// uncomment to debug
// echo $res;

msnhockey

no errors with the code at all anymore, but the query still isn't displaying right...

can querys work against each other?

BlueKai

Not sure what you mean by 'against each other'.

When you put the query directly into the database (in phpmyadmin or such), do you get the correct results?

Can you give us more of the code?

msnhockey

in phpmyadmin... i get the results that i get on my web page.. its almost that the $sid is not working.. i just want the current seasons games...

when i add seasons to the query. i get only the current games, but it comes up with 4 of the same game in the list

here is the code

$result_ss3 = mysql_query("SELECT * FROM schedule_scores WHERE "
	."(team1 = $team1 AND team2 = $team2) OR (team1 = $team2 AND team2 = $team1)  "
	."AND season = '$sid' "
        ."AND team1_score > '-' "
        ."AND team2_score > '-' "
	."ORDER BY date DESC LIMIT 12");

$i_ss = 0;
$total_rows_ss3 = mysql_numrows($result_ss3);

$schedule8 = ("
	<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
              <tr>
              <td bgcolor=\"#EEEEEE\">
                        <table width=\"100%\" border=0 cellspacing=1 cellpadding=0>\n");


while($i_ss < $total_rows_ss3) {
        $ssid = mysql_result($result_ss3,$i_ss,"id");
        $date = mysql_result($result_ss3,$i_ss,"date");
        $time = mysql_result($result_ss3,$i_ss,"time");
        $split_the_time = explode(":",$time);
	$time = date("g:ia", mktime($split_the_time[0], $split_the_time[1], 0));
        $location = mysql_result($result_ss3,$i_ss,"location");
        $team1 = mysql_result($result_ss3,$i_ss,"team1");
        $team2 = mysql_result($result_ss3,$i_ss,"team2");
        $team1_score = mysql_result($result_ss3,$i_ss,"team1_score");
        $team2_score = mysql_result($result_ss3,$i_ss,"team2_score");
	$gm_ot = mysql_result($result_ss3,$i_ss,"ot_game");

        $team1_id = $team1;
		$team2_id = $team2;

		$sql_team1_name = "SELECT name FROM teams WHERE id = '$team1'";
		$result_team1_name = mysql_query("$sql_team1_name");
		$team1 = mysql_result($result_team1_name,0,"name");
		$sql_team2_name = "SELECT name FROM teams WHERE id = '$team2'";
		$result_team2_name = mysql_query("$sql_team2_name");
		$team2 = mysql_result($result_team2_name,0,"name");
$t111_div = mysql_result($result_ss3,$i_ss,"team1_div");
$t222_div = mysql_result($result_ss3,$i_ss,"team2_div");
        //EDIT DATE
        $adate = explode("-",$date);
        $ndate = date ("M j", mktime (0,0,0,$adate[1],$adate[2],$adate[0]));

    //ROW COLOR
    $tbgcolor = is_int($i_ss / 2)?"#DFDFDF":"#EFEFEF";

    $schedule8 .= "
	<tr bgcolor=\"".$tbgcolor."\" align=\"center\">";

	if($team1_score == "" && $team2_score == "") {
		    $schedule8 .= "
	                  <td class=\"table_text8\" align=center>".$ndate."</td>";
	    } else {
	        $schedule8 .= "
		                <td class=\"table_text8\" align=center><b><a href=\"".$sport_dir."inc/showgame.php?id=".$ssid."\" onClick=\"NewWindow(this.href,'name','700','600','yes');return false;\">
				         ".$ndate."</a></b></td>";
}
            $schedule8 .= "
            <td class=\"table_text8\"><a href=\"./?opt=viewteam&id=$team1_id&divid=$t111_div&sid=$sid\">".$team1."</a></td>";
     if($team1_score > $team2_score) {
            $schedule8 .="
            <td class=\"table_text8\" align=center>";
            	if($gm_ot == 1) {
            	$schedule8 .= "<b><u>".$team1_score."</u></b></td>";
            	} else {
            	$schedule8 .= "".$team1_score."</td>";
            	}
     } else {
            	if($gm_ot == 1) {
            	$schedule8 .= "<td class=\"table_text8\" align=center><b><u>".$team1_score."</u></b></td>";
            	} else {
            	$schedule8 .= "<td class=\"table_text8\" align=center>".$team1_score."</td>";
            	}
     }

        if($team2_score > $team1_score) {
	    $schedule8 .="
	    <td class=\"table_text8\" align=center>";
            	if($gm_ot == 1) {
            	$schedule8 .= "<b><u>".$team2_score."</u></b></td>";
            	} else {
            	$schedule8 .= "".$team2_score."</td>";
            	}
	} else {
            	if($gm_ot == 1) {
            	$schedule8 .= "<td class=\"table_text8\" align=center><b><u>".$team2_score."</u></b></td>";
            	} else {
            	$schedule8 .= "<td class=\"table_text8\" align=center>".$team2_score."</td>";
            	}
        }
            $schedule8 .= "<td class=\"table_text8\"><a href=\"./?opt=viewteam&id=$team2_id&divid=$t222_div&sid=$sid\">".$team2."</a></td></tr>";

            $i_ss++;
   }
 if($i_ss == 0) {
                $schedule8 .= "<tr><td class='body_text' align='center' colspan='7'>-No Games Scheduled-</td></tr>";
        }


   $schedule8 .= "

              </tr></table></td></table>";

BlueKai

try putting extra ()'s around the team1/team2 'or'..

mysql_query("select * from schedule_scores where
[b]([/b](team1={$team1} and team2={$team2}) or (team1={$team2} and team2={$team1})[b])[/b]
and season='$sid' and team1_score>'-' and team2_score >'-' order by date desc limit 12");

msnhockey

worked like a charm.... what does the double quotes do

BlueKai

The parentheses changes the operator precedence. Before it was saying where

(t1=t1 & t2=t2) OR [ (t1=t2 & t2=t1) and (other stuff) ]

now it says where

((t1=t1 & t2=t2) or (t1=t2 & t2=t1)) AND (other stuff)

http://us.php.net/manual/en/language.operators.php#language.operators.precedence