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

cyrillic string conversion question
Hello,

First time here...

I would like to know if there is a way to convert a

how do i make a string??
hey guys,
can someone please tell me how to put data from the glob function into a string

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

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

Problem with the Update command used with a sqldataadapter
I'm connected to a database on an SQL Server and I'm using a sqldataadapter, sqlconnection, sqldatas

Character increment
Hi,

I am facing a scenario like above,but in my case i want to show up like Col A,Col B etc..

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items

Keeping data in form
How can I keep whatever I write in the form?

Local file browser with php
Halo..

So this is what i want to create. I have a folder that i share and it has many movies.

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,