[SOLVED] Can only add one record to a table

[BarneyJoe]

This is driving me nuts.

 

I basically use web assist's ecart with Protx's payment gateway.

 

It was all working fine with the customer registration / log in etc, but my client wanted that stripped out.

 

Having done that, realised I still needed the Orders table.

 

Have been playing around trying to populate a transaction ID field, and have noticed that for some reason I can only add one record to my orders table via the website - if I try to add any more, the don't get a record added.

 

I have no idea why this should be - either it should work or it shouldn't - what's causing it to add one record, but no more after that, even tho' the process is identical.

 

I haven't posted any of ecart's code yet - does anyone have any suggestions as to why only the first record gets added to the table, but all others after that do not?

[teng84]

post your code here

 

or check your connection

[BarneyJoe]

Have noticed that in fact it's overwriting the first record each time.

 

Also posted on web assist's forum, who mentioned that it's only supposed to hold one order at a time.

 

Not sure what's going on, as it was before....

 

I'll see if I can find out more from the web assist (DW externsions) guys.

[BarneyJoe]

Have been having a rummage, and think it was to do with a session needing to be unset - otherwise it was overwriting.

 

Have at least confirmed it doesn't do this if the browser is closed and re-opened - so it looks like I just need to unset the session and it'll be fine.

[BarneyJoe]

Yup - that seems to be fixed now.