add to cart problem

Hi,

I am building a ecommerce website with framework builder and ecart.
Everything is working ok.
In the detail product i have add to cart button and works fine, in the list products also.

But in the homepage, i have one recordset that select books order by rand() and limit 0,5.
That recordset shows 5 books in a div with a add to cart button, but sometimes when i click in the button the results just disappear.

If i remove the "limit 0,5" in the recordset everything works fine.

Anyone have a answer for this?

Regards

instead of setting the recordset to only return 5 records, set the repeat region to only show 5 records.


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.

Originally Said By: Jason Byrnes

  instead of setting the recordset to only return 5 records, set the repeat region to only show 5 records.


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

sure, the recordset will be returning more rows than it needs to but there is not another to offer a random selection.
the work flow is this:

the reordset is created and the page displays the add to cart button to the user, code at the end of the page destroys the recordset result set.

the user clicks the add to cart button which posts a form

the page relaods, creates the recordset, triggers the code to add the item to the cart which looks at the ID passed in and tries to find that record in the recordset results.



By using ORDER BY rand() LIMIT 0, 5 the recordset result used to create the page at first will not be the same as the results set when the add to cart button posts.