confirmation on form

amar3d

Hi, i have a form that enters dvd details into a database, what i dont know how to do is give confirmation that the dvd has been entered successfully by the user, so that once they submit the data a message comes up saying 'dvd entered', does anyone know how i can do this?...thanks in advance
AD

here is my code( i've cut the form down to just the DVD name to save space)

<?php
if (isset($POST['submit'])) {
$db = mysql_connect("localhost","username");
mysql_select_db("test",$db);
$dvd_name=$POST['dvd_name'];
$query = "INSERT INTO dvds (dvd_name)VALUES ('$dvd_name')";
$result = mysql_query($query);
}
?>
<html><head><title>DVD file</title></head><body>
<p>DVD File</p>
<TABLE cellSpacing=0 cellPadding=0 width=400 border=0>
<form name="dvd_form" method="post">
<TBODY>
<TR vAlign=top>
</TR></TBODY></TABLE>
<table width="44%" height="222" border=0 align=center>
<tbody>
<tr>
<td align=right>DVD Name </td>
<td><input size=35 name=dvd_name></td> </tr>
<tr><td align="center"><input type="submit" name="submit" value="Submit Information" /></td></tr>

</form></table> </TBODY></TABLE></body></html>

autocolismo

replace

$result = mysql_query($query);

with

if($result = mysql_query($query){
echo "query was sucessfull";
} else {
echo "something is wrong";
}