Quote:
|
Originally Posted by xcell67
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /include/func/func.db.php on line 125
I'm assuming that
Code:
$query = "AND $sql_tbl[products].avail > 0 AND add_date > $from_time AND add_date < $now_time ";
|
Looks more like it doesnt know which table "add_date" is from, so prefix it with xcart_products. to read xcart_product.add_date However in the code you probably need to make it:
Code:
$query = "AND $sql_tbl[products].avail > 0 AND $sql_tbl[products].add_date > $from_time AND $sql_tbl[products].add_date < $now_time "
But if thats not right, maybe run the query in phpMyAdmin and see if it works, iff not you can try building the query up or strip it down.