I'm getting an "invalid argument" error for my While loop....

[Jim R]

I'm getting an invalid argument error for my While loop.  I can't figure out why. 

 

$sql="SELECT * FROM schools ORDER BY class DESC,sectional ASC,team ASC";

$results = mysql_query($sql);

while ($team = mysql_fetch_assoc($results)) {

echo $team['school'] . '<br>';

}

 

 

Here is the error:

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/******/public_html/hoosierhoopsmagazine.com/resources/sectional_assignments.php on line 7

[AyKay47]

your ORDER BY clause is invalid.. read thheree documentation

[Adam]

You know what they say about assumption being the mother of all f**k ups? Always check for errors when you execute a query:

 

$results = mysql_query($sql) or trigger_error('MySQL error: ' . mysql_error());

[Jim R]

I've been looking at ORDER BY examples, and what I've found so far tells me to do it that way. 

 

I'll keep looking.

[Adam]

I can't actually see a fault with the ORDER BY, assuming the column names are correct. Check the error as I mentioned before...

[Jim R]

Adam, that was the error which was produced. 

[AyKay47]

perhaps I am misunderstanding the documentation.. debugging your query is always the first step.. using code like Adam posted.. once you receive an error it will make it easier to remedy this..

[AyKay47]

Adam, that was the error which was produced.

post the error please

[Jim R]

I did. 

[Jim R]

Even with Adam's code, it produces:

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jwrbloom/public_html/hoosierhoopsmagazine.com/resources/sectional_assignments.php on line 7

 

[AyKay47]

okay i don't think you're understanding.. lets try something more simple..

 

$sql="SELECT * FROM schools ORDER BY class DESC,sectional ASC,team ASC";

$results = mysql_query($sql) or die(mysql_error());

while ($team = mysql_fetch_assoc($results)) {

echo $team['school'] . '<br>';

}

[Jim R]

I am understanding.  I put the exact code Adam told me to put, and that was what it produced, which is what I posted in the response above.

[Jim R]

As usual, it's something stupidly simple, like a typo.  hschool instead of school. 

 

Thanks for your time guys.  Sorry it wasn't even a code issue. 

 

 

[AyKay47]

As usual, it's something stupidly simple, like a typo.  hschool instead of school. 

 

Thanks for your time guys.  Sorry it wasn't even a code issue. 

not a problem..

[Adam]

I am understanding.  I put the exact code Adam told me to put, and that was what it produced, which is what I posted in the response above.

 

Yeah sorry for the confusion, I missed out E_USER_ERROR for the second parameter. If you didn't see the MySQL error though it's likely you have warning messages hidden.