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
