Data insert

[Arsench]

Hello, the next code is in the reg_index.php and ind_index.php.

when Im clicking to insert data, its returns empty in db. even doesnt show on the page after clicking submit.Please is there any error?All the rest of code is work only this cant understand the problem.
The code is.

reg_index.php
///////////////////////////
<form action="ind_insert.php" >
.Nombre del Curso
<input name="name" type="text" id="name" >
<br>
Numero_indice
<input name="number" type="text" id="number">
<br>
Numero_programa
<input name="chapter" type="text" id="chapter" >
<br>
<input type="submit" name="Submit" value="ENVIAR">

</form>
/////////////////////////////// end of reg_insert.php
-----------------------------------------------------------------------------
the ind_insert.php
<?php
include'db.php'; //connection to DB

$name=$_POST['name'];
$number=$_POST['number'];
$chapter=$_POST['chapter'];

$q = "INSERT INTO prog VALUES ('','$name','$number','$chapter')";
if(!mysql_query($q))
{
die(' Error: ' .mysql_error());
}
else
{
echo"Data Inserted was:";
echo"<br>";
echo"<br>";
echo"$name";
echo"<br>";
echo"$number";
echo"<br>";
echo"$chapter";

}
/////// RETURNS EMPTY AFTER CLICKING ENVIAR //////////

?>
////////////// end of ind_insert.php

thank you very very much

[masterofollies]

Instead of this

$q = "INSERT INTO prog VALUES ('','$name','$number','$chapter')";

Try this

$q = "INSERT INTO prog VALUES (''name='$name',number='$number',chapter='$chapter')";

[CFMaBiSmAd]

Your <form tag is missing a method="post" parameter, so it is using the GET mode by default and the $_POST variables are not being set.

[Fumigator]

You need method="post" on your form tag.

(edit aww shoot I took too long to respond and CFMaBiSmAd beat me to it -- stupid job-related distractions)

[_Aerospace_Eng_]

Originally Posted by masterofollies

Instead of this

$q = "INSERT INTO prog VALUES ('','$name','$number','$chapter')";

Try this

$q = "INSERT INTO prog VALUES (''name='$name',number='$number',chapter='$chapter')";

And don't use that as it will error out. You also have an unneeded comma.

PHP Code:

$q = "INSERT INTO prog VALUES ('$name','$number','$chapter')"; 


[masterofollies]

Well it works on my website just fine.