sstoveld Posted December 9, 2009 Share Posted December 9, 2009 hey guys, having an issue here with my code... here it is: $select = mysql_query("SELECT * FROM stats LEFT JOIN standings ON standings.id = stats.team_id WHERE stats.team_id = '$team_id' ORDER BY stats.points DESC")or die(mysql_error()); what is the problem with this piece of code? here is a link to where my problem is on my site: http://gamera.caset.buffalo.edu/~sstoveld/DMS315/projects/final/standings.php when you click a link, it goes to the page for that team, but the table does not get populated with the data i am trying to put in there, it just stays blank if you need some more info, let me know, not sure if im forgetting anything. thanks for help in advance Link to comment https://forums.phpfreaks.com/topic/184491-problem-with-select-query/ Share on other sites More sharing options...
Goldeneye Posted December 9, 2009 Share Posted December 9, 2009 Well, this is more of a MySQL problem (which means you might get a better response to your problem in the MySQL Help forum). Also, the link you posted isn't useful for solving your problem as it just keeps redirecting to the login-page. What would be useful for you to provide: - The table structure(s) of the tables that you use in the query - Any errors you receive when the query is excuted I'm not intending to be mean-spirited, I'm simply giving you a few tips on what to provide to make solving your problem easier. Link to comment https://forums.phpfreaks.com/topic/184491-problem-with-select-query/#findComment-974039 Share on other sites More sharing options...
Philip Posted December 9, 2009 Share Posted December 9, 2009 We're going to need to see more code/info to be able to see any problems. Link to comment https://forums.phpfreaks.com/topic/184491-problem-with-select-query/#findComment-974154 Share on other sites More sharing options...
sstoveld Posted December 10, 2009 Author Share Posted December 10, 2009 sorry for the lack of info i encountered another problem and forgot i already had this one going link to the new thread: http://www.phpfreaks.com/forums/index.php/topic,280121.0.html i posted a lot more info in the new thread and the login info if possible, could a mod merge the two threads? thanks Link to comment https://forums.phpfreaks.com/topic/184491-problem-with-select-query/#findComment-974573 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.