I am not sure what it is but I have had my flash program working for a long time but did not notice this until someone emailed to let me know they never got there info.
My program I developed used the newstore flash shopping cart and was re-done extensively to make our own Drum set builder software.
Here is the link http://www.drumwerx.com/dreamkitbuilder.html
Users use the builder and get what they want quoted on as far as a custom drum set. I use AMF to get things from the database as well as some xml to load all of the flash pages in this swf.
Then at the very end they click on a get quote button to have the flash swf do 4 things using php scripts connecting to the database. What is strange is most of the time when you click on the button nothing happens. I have a note at that button that says if you do not see 4 messages please click on the get quote button again. It then works fine.
#1 update or insert the clients info(name, address and so on in the clients table). message #1 is either client inserted or client updated
#2 inserts into the database drum set general info. message #2 kit inserted
#3 inserts all the details of the drum set. message #3 is details inserted
#4 send me an email. message #4 is email sent
What I am also seeing is that 1 out of 3 times using the swf I do not get the email, #4, and do not have the details inserted in the 3rd script.
I am thinking that the insert into the details database table did not work and had errors but can't figure out what it is or where to look for the error or how to make an error show up in a log for me to see what I have to change in that php script to make this work. This has to be it!!
Here is the PHP script I have in #3.
function insertDetail($OrderID, $List) // List is a two dimensional array with FkProduct and Quantity
for ($i=0; $i<sizeof($List); $i++)
$result = mysql_query("Insert into details values('".$OrderID."', '".$List[$i]['Shell']."', '".$List[$i]['TopHead']."',
'".$List[$i]['BotHead']."', '".$List[$i]['Hoop']."', '".$List[$i]['Mount']."', '".$List[$i]['Bracket']."', '".$List[$i]['LugPos']."',
if(mysql_error()) return "error";
else return $OrderID;
Either this is not getting $orderID or $list correctly or there is the wrong info in $list because of how they used the swf and I have a bug in my code someplace.
If I could make something write to another file so I can see what is in it then I might be able to go back and fix what code I have done wrong to get it working correctly.
Is there a way to write this error to a sepearte file?