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
Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?I have a script that creates dynamic PDF documents, but want to save it as a file, rather than render it to the
Extra fields in main body and php required.
I'm new to PHP so please be gentle. I have a little php script below that works well. The "$msgVar" goes into the body message of the email. How can I effect additional fields that can be
need help about
i store the value of my select statement result to an array and stored it to a variable named $fname the i used it as the value of:<input type='text' name='fname' value=<?php echo $fname
Probably Easy, Need help with Check Boxes in PHP Code
hello,Thanks for looking this over and helping me out. My problem is I have a online store locator database and whats happening is I keep getting an "array" message when I look at the store.
Need to write a cookie with a url var
Not sure if its possible, but I need to write a cookie with a url.So this would write 2232 as the cookie for ID.http://www.example.com/redirect.php?ID=2232Ultimately, I'm working on a pixel tracking
show random images
hey guyscan someone please suggest a way in which the following code can be edited so it only picks up .jpg files, and so it only shows 20 of them which where found, in a randomized orderCode:
replacements
I have a variable in my PHP script like ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and positions 5-10I want to replace these positions with another color .$newpat="<font
Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought about my site, feel free to sign up an post items to see how that all works or if you dont want to
Retrieving Data from Two Different Databases
Hello All, Ran into another problem and would appreciate some help! I have two databases, publications_db (pub_id, title, author, yr, journal, num_pages) and
help me, how to find text on an external html site using PHP
Would anyone know how to search an external html file for a work or phrase ?I was thinking something like this --I use script cURL...Code: <?phpif (isset($_POST['submitted'])) { $xurl_1 =