Help a script with giving more detail.

**Dormilich** · Feb 23 '12, 06:56 AM

you mean listed point like in an <ul>?

**syoung69** · Feb 23 '12, 03:27 PM

Thanks for your reply Dormilich. No, i mean in the points column as shown here. Looking for the teams info to list team with highest points to lowest in order.

**Dormilich** · Feb 23 '12, 03:35 PM

you would do the ordering when you fetch/process the data. e.g. in SQL you would add an ORDER BY clause

**syoung69** · Feb 23 '12, 03:53 PM

THanks Dormilich but i am self taught and still struggle with certain code. Here is my SQL. Can you add a little light to my question?

:) Thanks again.

Code:

function index_team_stats($subconference) {

	$return = array();

	$query = "SELECT id, teamname, teamnameseason, teamabr FROM teams WHERE subconference = '" . $subconference . "' ORDER BY teamnameseason";

	$teams = result_array($query);

	foreach ($teams as $team) {

		$query = "SELECT gp, w, l, ol, p FROM season12 WHERE team = '" . $team['teamnameseason'] . "'";

		$results = result_array($query);

		if ($results) {

			$results[0]['team'] = str_replace($team['teamnameseason'], '', $team['teamname']);

			$results[0]['teamabr'] = $team['teamabr'];

			$results[0]['teamid'] = $team['id'];

			$return[] = $results[0];
		}
	}
	return $return;
}

**Dormilich** · Feb 23 '12, 04:15 PM

Can you add a little light to my question?

a little bit.

first of all is that you don't need two queries. you can combine both tables with a JOIN command.

Code:

SELECT 
    s12.gp AS gp,
 -- you would need aliases like the above for all values
 -- to access the data via associative array in the result
    s12.w, 
    s12.l, 
    s12.ol, 
    s12.p,
    teams.id, 
    teams.teamname, 
    teams.teamnameseason, 
    teams.teamabr 
FROM 
    season12 AS s12
JOIN
    teams
    ON s12.team = teams.teamnameseason
WHERE
    teams.subconference = ?
ORDER BY
    s12.gp

then you can fetch the data in one loop as desired. I may note that it would be more comfortable to use objects for the whole task, but I leave that for later.

**syoung69** · Feb 23 '12, 04:27 PM

Thanks. That helps me understand abit more. Now for the fetch data this is my code but im missing something. Im getting a error.

Code:

function result_array($query) {

	$results = mysql_query($query);

	$return = array();

	while ($row = mysql_fetch_assoc($results)) {

		$return[] = $row;

	}

	return $return;

}

**Dormilich** · Feb 23 '12, 05:40 PM

Im getting a error.

well, that possibility can never be ruled out.

(i.e. I can’t help without more details)

**syoung69** · Feb 23 '12, 06:53 PM

Sorry Dormilich... Here is the error i am getting...

Warning: mysql_fetch_ass oc(): supplied argument is not a valid MySQL result resource in /home/vhockey/public_html/vhatest/connect.php on line 104

This is line 104 --- while ($row = mysql_fetch_ass oc($results)) {

Thanks again.

**Dormilich** · Feb 23 '12, 11:13 PM

the usual suspect—your query failed.

try the following:

Code:

$results = mysql_query($query) or die("error on: " . $query . " saying: " . mysql_error());

**syoung69** · Feb 23 '12, 11:22 PM

Well, now this is the error i get...

error on: SELECT s12.gp AS gp,s12.w,s12.l, s12.ol,s12.p,te ams.id,teams.te amname,teams.te amnameseason,te ams.teamabr FROM season12 AS s12 JOIN teams ON s12.team = t eams.teamnamese ason WHERE teams.subconfer ence =&nbs p;? ORDER BY s12.gp . saying: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eams.teamnames eason WHERE teams.subconfer ence =&nbs p;? ORDER BY s12.gp' at line 7

Im all confused now.. hehe..

**syoung69** · Feb 23 '12, 11:24 PM

Here is my code as of now:

Code:

function index_team_stats($subconference) {



	$return = array();



	$query = "SELECT id, teamname, teamnameseason, teamabr FROM teams WHERE subconference = '" . $subconference . "' ORDER BY teamnameseason";



	$teams = result_array($query);



	foreach ($teams as $team) {



		$query = "SELECT s12.gp AS gp,s12.w,s12.l,s12.ol,s12.p,teams.id,teams.teamname,teams.teamnameseason,teams.teamabr 
FROM 
    season12 AS s12
JOIN
    teams
    ON s12.team = t
eams.teamnameseason
WHERE
    teams.subconference =&nbs
p;?

ORDER BY
    s12.gp . ";



		$results = result_array($query);



		if ($results) {



			$results[0]['team'] = str_replace($team['teamnameseason'], '', $team['teamname']);

			$results[0]['teamabr'] = $team['teamabr'];

			$results[0]['teamid'] = $team['id'];



			$return[] = $results[0];



		}



	}



	return $return;



}



function get_team_name($teamnameseason) {



	$query = "SELECT teamname FROM teams WHERE teamnameseason = '" . $teamnameseason . "'";



	$row = mysql_fetch_row(mysql_query($query));



	return str_replace($teamnameseason, '', $row[0]);



}



function result_array($query) {



	$results = mysql_query($query) or die("error on: " . $query . " saying: " . mysql_error());



	$return = array();



	while ($row = mysql_fetch_assoc($results)) {



		$return[] = $row;



	}



	return $return;



}



?>

**Dormilich** · Feb 24 '12, 06:14 AM

there are a couple of woes.

why do you have 2 queries again?

**syoung69** · Feb 24 '12, 03:53 PM

Hi Dormilich,
To be honest i am a disabled vet and i have someone come to my home once a week that teaches and helps me understand php code. It has been a long process but still learning. Your question of why 2 queries is well here is the whole connect page that may help u understand. This is minus the connect info.

Code:

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');



mysql_select_db($dbname);



function index_offensive_leaders($type) {



	$query = 'SELECT id, first, last, ' . $type . ', team FROM regularseasonskaters12 ORDER BY ' . $type . ' DESC LIMIT 5';



	return result_array($query);



}



function index_goalie_leaders($type) {



	$query = 'SELECT id, first, last, ' . $type . ', team FROM regularseasongoalies12 ORDER BY ' . $type . ' DESC LIMIT 5';



	return result_array($query);



}



function index_game_results() {



	$query = 'SELECT id, date, concat(right(date, 4), mid(date, 4, 2), left(date, 2)) AS concat_date, home, away, homescore, awayscore FROM gamestats12 WHERE date <> \'date\' ORDER BY concat_date DESC LIMIT 20';



	return result_array($query);



}


    

function index_team_stats($subconference) {



	$return = array();



	$query = "SELECT id, teamname, teamnameseason, teamabr FROM teams WHERE subconference = '" . $subconference . "' ORDER BY teamnameseason";



	$teams = result_array($query);



	foreach ($teams as $team) {



		$query = "SELECT s12.gp AS gp,s12.w,s12.l,s12.ol,s12.p,teams.id,teams.teamname,teams.teamnameseason,teams.teamabr 
FROM 
    season12 AS s12
JOIN
    teams
    ON s12.team = t
eams.teamnameseason
WHERE
    teams.subconference =&nbs
p;?

ORDER BY
    s12.gp . ";



		$results = result_array($query);



		if ($results) {



			$results[0]['team'] = str_replace($team['teamnameseason'], '', $team['teamname']);

			$results[0]['teamabr'] = $team['teamabr'];

			$results[0]['teamid'] = $team['id'];



			$return[] = $results[0];



		}



	}



	return $return;



}



function get_team_name($teamnameseason) {



	$query = "SELECT teamname FROM teams WHERE teamnameseason = '" . $teamnameseason . "'";



	$row = mysql_fetch_row(mysql_query($query));



	return str_replace($teamnameseason, '', $row[0]);



}



function result_array($query) {



	$results = mysql_query($query) or die("error on: " . $query . " saying: " . mysql_error());



	$return = array();



	while ($row = mysql_fetch_assoc($results)) {



		$return[] = $row;



	}



	return $return;



}



?>

Here is my temp site location... It will be updating the old site once finished. Alot of work to be done.

Page not found – Virtualhockeyassociation.com

https://www.virtualhockeyassociation.com/vhatest/index.php

Thanks for all your help.

Help a script with giving more detail.

Help a script with giving more detail.

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment