Help regarding Insert

Manat

Hello

I have a flash form that sends variable with LoadVariables.
It works, no problem there.

But is there something wrong with my php code, because it's not getting inserted into the database, MySQL, and I don't see any php errors in my logs.

<?
require("db.inc.php");
$today = date("F j, Y, g:i a");

$cnt="join";
$type="web";

$i = 0;
if( $promocode == 5455 )
{
for ($i = 1; $i <= 5; $i++) {
$sql = "INSERT INTO contest (age,fname,lname,address,city,state, country, contest, ZipPostal, date, type, question, promo)

   VALUES ( '$age', '$fname', '$lname', '$address', '$city', '$stateprov', '$country', '$cnt','$zip', '$today', '$type', '$product', '$promocode')";

}
$result = mysql_query($sql) or die(mysql_error());

}
else
{
$sql = "INSERT INTO contest (age,fname,lname,address,city,state, country, contest, ZipPostal, date, type, question, promo)

   VALUES ( '$age', '$fname', '$lname', '$address', '$city', '$stateprov', '$country', '$cnt','$zip', '$today', '$type', '$product', '$promocode')";

   $result = mysql_query($sql) or die(mysql_error());

}

As you can see, if they enter a promocode equal to 5455, then their entry goes into the DB 5 times.

Can anyone let me know if something is wrong with my PHP code?

Thank You
MK

tomhath

Here's your code, trimmed down a little. You are setting $sql five times but only calling mysql_query once after you exit the "for" loop. So the row will only be inserted one time.

for ($i = 1; $i <= 5; $i++) { 
   $sql = ...; 
} 
$result = mysql_query($sql) or die(mysql_error());

Manat

Yep, stupid error on my part, it's corrected

{
for ($i = 1; $i <= 10; $i++) {
$sql = "INSERT INTO harley (age,fname,lname,address,city,state, country, contest, ZipPostal, date, type, question, promo)

   VALUES ( '$age', '$fname', '$lname', '$address', '$city', '$stateprov', '$country', '$cnt','$zip', '$today', '$type', '$product', '$promocode')";
   $result = mysql_query($sql) or die(mysql_error());

}

But still, this doesn't explain why I am not seeing anything in the database, and i'm not even getting any PHP log errors....

Help!!!!

kevinsequeira

debug : echo $sql to see what it is

reg
kevin

stolzyboy

ya know, i am trying to help you on your other EXACT post, DON'T DOUBLE POST, it is kinda hard to help you when you bounce all over the frickin place