Re: function not returning query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Likely your query failed due to an error.

Try adding an or die(mysql_error()) to the end of your mysql_query statement to see what that error maybe

Bastien

Sent from my iPod

On Nov 23, 2009, at 7:22 PM, Allen McCabe <allenmccabe@xxxxxxxxx> wrote:

Hi, thanks for reading, I hope you can help:

In my main file for an orders page I have the following code:


if (isset($_GET['filterby']))
{
 $resultOrders = adminFilterQuery();
 $numberOfOrders = mysql_num_rows($resultOrders);
}
else
{
 $resultOrders = mysql_query("SELECT * FROM afy_order;") or
die(mysql_error("Could not query the database!"));
 $numberOfOrders = mysql_num_rows($resultOrders);
}


adminFilterQuery() is a custom function that is supposed to return a
mysql_query, here are the last few lines of this function:


$query = "SELECT * FROM afy_order WHERE school_id = '{$school}' ORDER BY
{$order_by_param};";
$result = mysql_query($query);
return $result;

l am getting this error when I try to filter my query using a form in tandem
with the quey building function:

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

where the line is the one where I use the mysql_num_rows function.

What am I missing here?

Thanks!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux