php/database problem

[Anon]

On my webpage, there's a form for people to input their information. I use php to send those data to mySQL database and then send the user an confirmation email and redirect the user to another site after clicking submit.

The problem is that the data aren't getting to the database, though the user still gets the confirmation email and gets redirected to another webpage. Like it just skips the writing part.

I get absolutely no error message in the process. What could be the problem??

Thanks

[Anon]

Can we see what you have done so far so we can help you better

Pradeep Dsouza

Aspbyte Creations

[Anon]

Code attached.

The funny thing is that the whole thing has been working fine for me the last 2 days, and it suddenly stopped working!

I have got 200 records already in the database already, so I assume that the code is fine... I just don't know what went wrong all of a sudden.

require("config.php");

//echo "From posted script ";
//echo "Winner :".$winner;
//echo "e_mail :".$e_mail;
$date_now = date('Ymd');
$result = DBquery("INSERT INTO contest1 (winner, e_mail,firstname,lastname,age,country,phone,fav_league,fav_team,ref_email1,ref_email2,newsletter,lang,reg_date)
VALUES ('".$winner."', '".$e_mail."','".$firstname."','".$lastname."','".$age."','".$country."','".$phone."','".$fav_league."','".$fav_team."','".$ref_email1."','".$ref_email2."','".$newsletter."','".$lang."','".$date_now."')");