php HELP

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

Could be that there is no script to connect to the database. Could have errors turned off on the server. Could be that the data is getting there, and you aren't retreiving it properly. Could be that someone stole your database server and and is hijacking your data. Could be lot's of things.

What platform are you using and can you show us the code that is not working?

Anon

Thanks for the reply.
The funny thing is that it's been working properly. I have had 200 records already in the database, but it just suddenly stopped working!

The following is the code that writes data to the database when people clicks on the submit button. Any problems with the code?

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."')");

Thanks

Anon

You need to eliminate all the concatenating from the second half of your query string.

Make it look like this
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, etc..