Jump to content

Problem with select query


sstoveld

Recommended Posts

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

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.

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.