Help a script with giving more detail.

8,658

Expert Mod 8TB

you mean listed point like in an <ul>?

Feb 23 '12 #2

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.

Feb 23 '12 #3

8,658

Expert Mod 8TB

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

Feb 23 '12 #4

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.

Expand|Select|Wrap|Line Numbers

 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;

}

Feb 23 '12 #5

8,658

Expert Mod 8TB

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.

Expand|Select|Wrap|Line Numbers

 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.

Feb 23 '12 #6

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

Expand|Select|Wrap|Line Numbers

 function result_array($query) {
 
    $results = mysql_query($query);
 
    $return = array();
 
    while ($row = mysql_fetch_assoc($results)) {
 
        $return[] = $row;
 
    }
 
    return $return;
 
}

Feb 23 '12 #7

8,658

Expert Mod 8TB

Im getting a error.

well, that possibility can never be ruled out.

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

Feb 23 '12 #8

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

Warning: mysql_fetch_assoc(): 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_assoc($results)) {

Thanks again.

Feb 23 '12 #9

8,658

Expert Mod 8TB

the usual suspect—your query failed.

try the following:

Expand|Select|Wrap|Line Numbers

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

Feb 23 '12 #10

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

error on: SELECT s12.gp AS gp,s12.w,s12.l,s12.ol,s12.p,teams.id,teams.teamnam e,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 . 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.teamnameseason WHERE teams.subconference =&nbs p;? ORDER BY s12.gp' at line 7

Im all confused now.. hehe..

Feb 23 '12 #11

Here is my code as of now:

Expand|Select|Wrap|Line Numbers

 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;
 
}
 
?>

Feb 23 '12 #12

8,658

Expert Mod 8TB

there are a couple of woes.

why do you have 2 queries again?

Feb 24 '12 #13

Typing tutor help script needed, please

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.

Expand|Select|Wrap|Line Numbers

 $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.

www.virtualhockeyassociation.com/vhatest/index.php

Thanks for all your help.

Feb 24 '12 #14

Similar topics

by: Throw | last post by:

G'day everyone! I would like to design typing tutor exercises for Afrikaans (and other languages possibly). This is for a GPL project. For this, I need a script that can extract words from a...

Python

Need help with Master/Detail scenario

by: Michael Rodriguez | last post by:

I have what I believe to be a typical master/detail scenario. I know how to use a transaction on the sql updates, but what about any dataset merges? My scenario goes like this: // call data...

C# / C Sharp

permissions and script 'visibility'

by: Dave Schwimmer | last post by:

I am relatively new to PHP. One of the things that seems glaring obvious to me (coming from a C/C++ background) is how 'open' everything seems - (AFAIK). For instance, URLs typically have the name...

PHP

Help with master detail please

by: Rick | last post by:

Hi guys, i did this sample http://www.15seconds.com/Issue/051117.htm and it works perfect, now im doing my own tables but i have a problem, when i add new row to datagridview it doesn't insert...

C# / C Sharp

HELP! script to sent auto SMS

by: hrakbari | last post by:

hi vijay im looking for script to Send SMS from Meteor.ie site, but the problem is that body of text has to copy content of text file and also the reciptioner mobile is saved in a text file also....

Java

Debug Help - Script to edit a flat file DB

by: deppeler | last post by:

Can someone look at this for me: I am trying to set up a script to edit an item in a flat file DB but I don't seem to be getting the data to the Photoedit script. It seems to be reading the 1st line...

Perl

Help with Master Detail connections

by: mvmashraf | last post by:

Hai Every One(Help ME) I have a datalist in that using item template the data is loaded. When i click on the item the corresonding detailed informations is loaded. My doubt is...

.NET Framework

[Help] Script to get contents of a function from other file.

by: Kesavan | last post by:

I need a function such that it returns a string holding the contents of function in other php file.., ...

PHP

Need help, script to block certain images from certain sites

by: dbase | last post by:

Hey guys, I'm new here. Sorry if this is not the correct forum for my question. I run a blog that gets a lot of comments from people. But often I have a problem with spammers that post images...

Javascript

Help - script stopped working

by: garethharvey | last post by:

Hello, I am new here, but read many posts over the past year or so which has helped my business. We have a dedicated server running a script to call a remote XML file using the following code: ...

ASP / Active Server Pages

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?