Php/query will not work

[pungi]

Hi,
I am trying to insert a value into an exisitng table but it does not insert the value, just a blank nothing. Apart from that it is working. The main part of the script is:

$query = "INSERT INTO $sched (task) VALUES ('$task')";

$i=0;
for($i=0;$i<12; $i++){
if ($_POST["task$i"]<>''){
$task=addslashes($_POST["task$i"]);
mysql_query($query) or die(mysql_error());
}
}

Thanks in advance,
Pungi

[pungi]

Hi,
I was convinced that the query was ok as im sure i tested it but i was wrong. I still havent found the problem but it definately is concerned with
"VALUES ('$task')" part of the query as the following query inserted 'jack' into the table:

$array= array(jack);
$query = "INSERT INTO $sched (task) VALUES ('$array[0]')";
Thanks, and sorry for posting this into the php forum when it was an sql error,
pungi

[pungi]

Hi,
Ignore the last post for I dont have a clue with whats wrong with it, it just inserts null values into the table.
Thanks,
pungi

[sde]

try this:

PHP Code:

<?
$i=0;
for($i=0;$i<12; $i++){

  $task = $_POST["task".$i]
  if ($task) {

    $query = "INSERT INTO ".$sched." (task) VALUES ('".mysql_real_escape_string($task)."')";
    mysql_query($query) or die(mysql_error());
  }
}
?>

[pungi]

Hi,
Thanks a bunch. It works but for now, i will call it magic and try to understand it at a later date.
Thanks again,
Pungi

[sde]

i insist u look at the code

you were setting your $query variable once, .. before the loop. you needed to set it in each iteration of the loop.

you were also setting $task in your query string. that contained nothing.

in the loop, you then modified $task as it should have been, .. but the variable $task does not maintain its reference inside the $query string.

[pungi]

Thank you also for the explanation. I understand it now; probably would not have without it.