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

Problems with returning true or false in eval()'d code
Hi guys,

Would appreciate some help with a problem when running eval() on a function that sho

Add User script "Could not execute query"
This should be an easy script but I can't get it to run. Can someone please help me?

<

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

PHP and MySQL Question/Help
I have a MySQL db with all my servers and all their details like server name, IP, OS, RAM etc etc 26

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

Custom array sort? asc then desc
Any ideas how I could sort this array? I've been trying for a while. Maybe with usort, but I have no

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

Production Order Enterprise Service to Manufacturing Exctn Sys (MES) ???
Hello Experts,

In our current landscape SAP ECC 5.0 is integrated to MES system via PI 7.

Bit manipulation program with binary operations
My homework is to create a program to scan in and add binary numbers and print them like so