Aug 28th, 2010, 8:27 AM
Hi Aluwe,
That's a perfectly decent approach - I don't see anything wrong with it in principle; it looks like there's just a bug occurring somewhere down the line.
A couple of things to check:
1. So the ce_response, ce_transref etc. fields are the database field names, correct? Not just the form field names? I always forget this myself, so double-check that.
2. Are you sure that SQL is in fact getting executed? Echo "here" in the if($cedata=='datacode') clause. Also, stick an "or die()" to the end of the query for a little debugging:
But assuming that cetxref is unique across all submissions in the table, I don't see anything wrong at all.. Very possibly it's data-oriented: the content being fed back to you doesn't have the values you're expecting.
Let me know how it goes! Interesting one.
- Ben
That's a perfectly decent approach - I don't see anything wrong with it in principle; it looks like there's just a bug occurring somewhere down the line.
A couple of things to check:
1. So the ce_response, ce_transref etc. fields are the database field names, correct? Not just the form field names? I always forget this myself, so double-check that.
2. Are you sure that SQL is in fact getting executed? Echo "here" in the if($cedata=='datacode') clause. Also, stick an "or die()" to the end of the query for a little debugging:
PHP Code:
mysql_query($query) or die(mysql_error());
But assuming that cetxref is unique across all submissions in the table, I don't see anything wrong at all.. Very possibly it's data-oriented: the content being fed back to you doesn't have the values you're expecting.
Let me know how it goes! Interesting one.
- Ben