the rand() functions changes the order, the limit function limits the results to only 5 records.
these two together will cause the recordset to return different results each time, so the record for the item being added to the cart no longer exists.
Hi Jason,
Thanks for your quick reply.
Ok, but i will not have problems of performance if the recordset retrieves 1000 rows?!
Usually i use limit int the sql statment because of performance concerns.
And your solution (that works) will not have a lot of rows to show, than the repeat reagion just show 5?
Waiting,
Regards