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

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

Effort Estimation Template for Steady State Support
Hi Everyone,

Is there any SAP provided template/format for system change and enhancements

Remote Database Access
Hey guys!!

OK, i'm used to only working with databases from the CPANEL, accessing phpMyAdmin

Creating web pages by php
Hello again,
I was just wondering us there a way to use a php script to create a new web page. I

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

Parse String
I need to parse the string below into three variables. How would I do that?

john + 10/20/2008

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

If a form submits back to same page do you need to use $get
IM trying to pass page number and year that was selected back to the same page.

i have this c