adding data into mysql

zuessh

I am following the tutorial on webmonkey for inserting data into a mysql database. I've basically cut and pasted the code from the tutorial and changed the code to fit my database, however it is not entering data. Any suggestions, Thanks

html>

<body>

<?php

if ($submit) {

// process form

$db = mysql_connect("localhost", "testphp", "test") or die("couldnt connect");

mysql_select_db("php",$db);

$sql = "INSERT INTO phptest (id,name,address,phone) VALUES ('$id','$name','$address','$phone'
)";

$result = mysql_query($sql);

echo "Thank you! Information entered.\n";

} else{

// display form

id:<input type="Text" name="id"><br>

name:<input type="Text" name="name"><br>

address:<input type="Text" name="address"><br>

phone:<input type="Text" name="phone"><br>

</form>

<?php

} // end if

</body>

</html>

kevinsequeira

after this line

$result = mysql_query($sql);

type this
echo $sql;
if(mysql_error()){
echo mysql_error();
}

also u might trychanging

$sql = "INSERT INTO phptest (id,name,address,phone) VALUES ('$id','$name','$address','$phone'
)";

$sql = "INSERT INTO phptest (id,name,address,phone) VALUES ($id,'$name','$address','$phone'
)";

remove the quotes ' ' before and after $id

any luck ? what output did it print
reg
kevin

zuessh

No output to the screen, just takes me back to the form page.

Still nothing entered into database and no error reported. I will post the code again with the changes. Also the name of my db is php and table is phptest. Maybe it is this line?:

I do not have a varialbe set for $PHP_SELF,

Below is code.

<html>

<body>

<?php

if ($submit) {

// process form

$db = mysql_connect("localhost", "testphp", "test") or die("couldnt connect");

mysql_select_db("php",$db);

$sql = "INSERT INTO phptest (id,name,address,phone) VALUES ($id,'$name','$address','$phone')"
;

$result = mysql_query($sql);

echo $sql;
if(mysql_error()){
echo mysql_error();
}

echo "Thank you! Information entered.\n";

} else{

// display form

id:<input type="Text" name="id"><br>

name:<input type="Text" name="name"><br>

address:<input type="Text" name="address"><br>

phone:<input type="Text" name="phone"><br>

</form>

<?php

} // end if

</body>

</html>