Error in query: Resource id #4??

Posted on 16th Feb 2014 07:03 pm by admin

hey guys, having a minor (i think) problem here that i havent been able to figure out. long story short, im building a hockey stat tracking site for a local hockey league around here.

my problem is, i am trying to run a query using php, but the value getting returned is Resource id #4 instead of what it is supposed to be. i read around and found people saying you need to use mysql_fetch_array, which is what i am doing. let me start by posting my code:

Code: <?php
$querystats = mysql_query('SELECT * FROM stats ORDER BY team_id');
$statsresult = mysql_query($querystats);
if (!$statsresult) {
exit ('<p>Error in query.'. mysql_error().'</p>');
}

while($row = mysql_fetch_array($statsresult)) {
echo $row['team_id'];
print_r($team_id);

$querystandings = mysql_query('SELECT * FROM standings ORDER BY points DESC');
if (!$querystandings) {
exit ('<p>Error in query.'. mysql_error().'</p>');
}

while ($row = mysql_fetch_array($querystandings)) {
echo('<tr><td>' . '<a href="teams.php?team_id='.$row['team_id'].'"> ' . $row['team'] . '</a></td><td>' . $row['games_played'] . '</td><td>' . $row['wins'] . '</td><td>' . $row['losses'] . '</td><td>' . $row['ties'] . '</td><td>' . $row['points'] . '</td></tr>');
}
}
?>
i believe the problem is the $querystats. here's what my table structure looks like:



here's a link to my site:
http://gamera.caset.buffalo.edu/~sstoveld/DMS315/projects/final/standings.php

you can login with: username: test password: test

the problem is on the standings page, if you hover over a team name and look at where the link directs to, it ends with team_id=

i need to get the proper team_id in the link, which is where im hoping someone can help me. ive been looking through this trying many different things that i cant seem to get to work.

if my above code is completely wrong with using the $querystats query, how can i get this to work.

originally the $querystats query wasnt there, and only the $querystandings query was being used, but the links wouldnt work because i am not selecting the team_id from the stats table. when i modify the $querystandings query to left join on stats, the loop goes through and adds about 25 entries per team, which is not what i want.

if you need any more info, please ask, i cant figure this out

Your Answer:

Login to answer

Other forums

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

losing variables between php brackets
Hi

have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys

MII Netweaver Server stopped due to CPIC connection Problem
Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

Using Curl_multi for processing multiple URLs
Hi,

I am at a loss as to how to implement this. I would like to be able to automatically assi

Format String help
I have a textbox where a person enters an application number. the application number is 10 characte

Calling a Procedure with IN & OUT Parameters
Hello,

I usually call my procedures using the following way

declare variable e

replacements
I have a variable in my PHP script like

ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and p

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
OK, I think but have a problem, only 1 pro

use an array from 1 class in a second class
I have a class that adds data to an array

Then I have a second class and I need to check if t