[RESOLVED] LIMIT function to show previous game

[msnhockey]

Hi there,

Below is my code for showing next game played and previous game played. In my previous game played it keeps showing only the first game in the DB. is there a way to change something in this script to show the previous game played. I have been trying for days, but can't seem to get any where

<?php


view_team($id,$sid);

//LIST TEAMS FUNCTIONS

function view_team($id,$sid) {

include("config.php");

//LOAD THE HTML
$filename = $sport_dir."html/schedule_body2.html";
$fd = fopen ($filename, "r");
$contents = fread ($fd, filesize ($filename));
fclose ($fd);

$open = mysql_connect($hostname,$user,$password);
mysql_select_db("$db",$open);




$result_info = mysql_query("SELECT * FROM teams WHERE id = '$id'");



//GET CURRENT SEASON
$result_season = mysql_query("SELECT name FROM seasons WHERE id = '".$sid."'");
$seasonname = mysql_result($result_season,0,"name");


//GET CURRENT DIVISION
		$result_division = mysql_query("SELECT division FROM teams WHERE id = '".$id."'");
		$divisionname = mysql_result($result_division,0,"division");
		$result_division2 = mysql_query("SELECT name FROM divisions WHERE id = '".$divisionname."'");
		$divisionname2 = mysql_result($result_division2,0,"name");








 $result_schedules_scores = mysql_query("SELECT * FROM schedule_scores WHERE season = '000000000001' AND team1_score IS NOT NULL AND team2_score IS NOT NULL LIMIT '$limit'");


$limit = -1;

$schedules_scores_date = mysql_result($result_schedules_scores,0,"date");
$schedules_scores_location = mysql_result($result_schedules_scores,0,"location");
$schedules_scores_team1 = mysql_result($result_schedules_scores,0,"team1");
$schedules_scores_team2 = mysql_result($result_schedules_scores,0,"team2");
$schedules_scores_team1score = mysql_result($result_schedules_scores,0,"team1_score");	
$schedules_scores_team2score = mysql_result($result_schedules_scores,0,"team2_score");
$team1_name = mysql_result($result_schedules_scores,0,"teamname");
$team2_name = mysql_result($result_schedules_scores,0,"team2name");
$team1pic = mysql_result($result_schedules_scores,0,"team1pic");
$team2pic = mysql_result($result_schedules_scores,0,"team2pic");






 $result_schedules_scores1 = mysql_query("SELECT * FROM schedule_scores WHERE season = '000000000001' AND team1_score = ' ' AND team2_score = ' ' ORDER BY 'date' LIMIT 1");

$schedules_scores_date = mysql_result($result_schedules_scores1,0,"date");
$schedules_scores_location = mysql_result($result_schedules_scores1,0,"location");
$team1name = mysql_result($result_schedules_scores1,0,"teamname");
$team2name = mysql_result($result_schedules_scores1,0,"team2name");

$team11pic = mysql_result($result_schedules_scores1,0,"team1pic");
$team22pic= mysql_result($result_schedules_scores1,0,"team2pic");













$contents = eregi_replace("<!--%TEAM11PIC%-->",$team11pic,$contents);
$contents = eregi_replace("<!--%TEAM22PIC%-->",$team22pic,$contents);
$contents = eregi_replace("<!--%TEAM11%-->",$team1name,$contents);
$contents = eregi_replace("<!--%TEAM22%-->",$team2name,$contents);
$contents = eregi_replace("<!--%TEAM1PIC%-->",$team1pic,$contents);
$contents = eregi_replace("<!--%TEAM2PIC%-->",$team2pic,$contents);
$contents = eregi_replace("<!--%TEAM1%-->",$team1_name,$contents);
$contents = eregi_replace("<!--%TEAM2%-->",$team2_name,$contents);
$contents = eregi_replace("<!--%TEAM2SCORE%-->",$schedules_scores_team2score,$contents);
$contents = eregi_replace("<!--%TEAM1SCORE%-->",$schedules_scores_team1score,$contents);
$contents = eregi_replace("<!--%SCHEDULE%-->",$schedule,$contents);
$contents = eregi_replace("<!--%LEAGUE_TITLE%-->",$league_name,$contents);
$contents = eregi_replace("<!--%SEASON_TITLE%-->",$season_name,$contents);
$contents = eregi_replace("<!--%TID%-->",$id,$contents);
$contents = eregi_replace("<!--%SID%-->",$sid,$contents);

echo $contents;

}

?> 

thanks mike 🆒

[Blulagoon]

$result_schedules_scores1 = mysql_query("SELECT * FROM schedule_scores WHERE season = '000000000001' AND team1_score = ' ' AND team2_score = ' ' ORDER BY 'date' LIMIT 1");

I cannot tell from your code if this is the relevant part, but ORDER BY DATE here will pull out the oldest date found by the query. ORDER BY DATE DESC would pull out the newest date found by the query.

HTH - Blu

[msnhockey]

so if i use the DESC after date it will bring the most current, correct.

mike

[msnhockey]

sorry this is the part of the code I am having trouble with

	 $result_schedules_scores = mysql_query("SELECT * FROM schedule_scores WHERE season = '000000000001' AND team1_score IS NOT NULL AND team2_score IS NOT NULL LIMIT 1");

this shows the previous gmaes played and the one you had shows the next game to be played

thanks

mike

[Blulagoon]

AND team2_score IS NOT NULL LIMIT 1");

Try

AND team2_score IS NOT NULL ORDER BY DATE DESC LIMIT 1");

Blu

n.b. I'm assuming that table also has a date column.

[msnhockey]

Hey all,

thanks for the help part of that did get what I needed plus alittle more. I will mark this as resolved and thanks again to who have helped me.

thanks 🙂