Due to math in query there is an error

heraldic2

Everything works when you first visit the page, however when you leave the page and return there are errors that pop up only on the queries that contain math.

My question is how can I stop or silence these errors?

Here is one of the queries:

<?php 
//Worst Regular Season Record

include_once('../other/functions.php');

$con = mysql_connect($hostname, $username, $password) 
	OR DIE ('Unable to connect to database! Please try again later.');
	$db = mysql_select_db($dbname, $con);

$query = "SELECT win, loss, year, teamname FROM standings, owners WHERE owners.owner_id = standings.owner_id AND win = (SELECT MIN(win) FROM standings) AND standings.owner_id = $thing ORDER BY year";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

@ mysql_data_seek($result, 0);

if(mysql_num_rows($result)>0) {

echo "<table CELLPADDING=5 border =1>";
echo "<tr>";
echo "<th align=center colspan=4 > Worst Regular Season Record </th>";
echo "</tr>";

while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo '<td align=center> In '.$row['year'].', the '.$row['teamname'].' had '.$row['win'].' wins, and '.$row['loss'].' losses.</td>';
echo "</tr>";
}
} else {

}
echo "</table>";

mysql_close($con);
?>

Thanks for the help.

bradgrafelman

What are the errors? Also, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

heraldic2

My apologies for not using the right submit format.

The two errors are:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

and

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Thanks again for working on this

Derokorian

...standings.owner_id = $thing...

Where is $thing defined? Because your query is what is failing... after your query add (for debugging only):


$result = mysql_query($query) or DIE("Mysql Error: (". mysql_errno() .") ". mysql_error() ."<br />". $query);

heraldic2

$thing is defined in functions.php

The query works as intended, the problem is if you leave the page and then return the page is populated with the above errors. You can then do a search and the errors go away and the query works. I would love to know how to make the errors not show up after you leave the page.

My guess, and it is very uneducated, is that the (SELECT MIN(win) FROM standings) is the problem as I have other queries on the page with much the same set up, except no math in them and no errors ever pop up.

bradgrafelman

Why 'guess' as to what the problem is?

You should always be checking to see if [man]mysql_query/man returns boolean FALSE (indicating an error has occurred) and, if so, either outputting or logging (as appropriate) debug info (such as the error returned by the MySQL server - see [man]mysql_error/man - and the SQL query string itself, as it was sent to MySQL).

heraldic2

As per your suggestion I placed the code after the query. I left the page and came back and the error message stated that I have a syntax error in the query, however I know the query works.

That is not the problem, when I run the query the query works exactly as it is supposed to.

The problem is that when I X out of the page, then return to that same page later the errors are already there. Then when I run the query it works perfectly and the errors are gone.

bradgrafelman

heraldic2 wrote:
however I know the query works.

Oh? Well I know the query doesn't work, because:

heraldic2 wrote:
the error message stated that I have a syntax error in the query

Did you output the SQL query as well? If so, can you paste it here for us to see?

Derokorian

you could just echo the query, without error to see what changes in the query between working and not working =D