posting problem with action parameter !!

[mnassih]

My problem is :
I have a query like :
----
$query = "INSERT INTO conge (matricule, nom, responsable, de, a, approuver) VALUES ('$matricule','$nom','$resp', '$de','$a','$approuver')";

mysql_query($query) or die(mysql_error());
-----
when I use :
<form action=demapprobconge.php method="POST">
the data does not insered in the database.

but when I use :

<form method="POST"> -Without action parameter-

It works !!

please help.

 

[jpadie]

add the following

echo $query;

just before this line

  mysql_query($query) or die(mysql_error() . "<br/>sql etait: $query<br/>");

and post the query back.

 

[mnassih]

Result :

INSERT INTO testdate(datedeb) Values ('2007-09-09')

and It works without :
---
...
else
{

echo "<form action='demapprobconge.php' method='post'>";

}
...
---
when I stay in the same form it works, but when I add :
echo "<form action='demapprobconge.php' method='post'>";

to open a confirmation form it does not work.

 

[jpadie]

that is to be expected since you do not have any form processing code in demapprobconge.php.

 

[mnassih]

processing code ? what does mean ? and how can I avoid this problem ?

 

[jpadie]

it is not a problem.

in html, the broswer sends the form values on submit to the url specified in the action parameter of the form. it is this file that must do the processing (put simply).

in your posts above, you have said that the file in your action parameter does nothing more than echo a "received" bit of text.