Nev Posted November 19, 2002 Share Posted November 19, 2002 I have installed this along side FreeCall V4.0 but I'm getting the following error when enabling the Featured Products. 1064 - You have an error in your SQL syntax near 'rand() DESC limit 6' at line 1 select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 any ideas any one, please. Nev :? Quote Link to comment Share on other sites More sharing options...
Ajeh Posted November 19, 2002 Share Posted November 19, 2002 I have never touched that select that I know of in my code. I think that would be a Featured Products issue. Quote Link to comment Share on other sites More sharing options...
Nev Posted November 19, 2002 Author Share Posted November 19, 2002 Gary MySQL 3.22.32, PHP 4.2.1 Nev Quote Link to comment Share on other sites More sharing options...
Nev Posted November 19, 2002 Author Share Posted November 19, 2002 After doing some testing it looks like the rand() is not support in my versions of mySQL. So will have to upgrade to 3.23.2 or change the statement. Can any one suggest a replaced statement that will provide the same random effect. Nev Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.