help with submitting to database

[jharrington]

i need help with a bit of code basically i want to be able to send information to database by clicking a submit button. here is the particular code i have so far

<?
if($submit)
{
$sql = "INSERT INTO shoppinglist3 (productname,price,tablename) VALUES ('$productname','$price','$table')";
$result = mysql_query($sql);
}
?>

<form method="post" action="">
<input type="Submit" name="submit" value="Submit">
</form>

this does not work properly any ideas would be appreciated
cheers
john

[vaaaska]

Ummm, because you aren't inserting anything into the database according to what you have posted...

[jharrington]

no sorry if i didnt explain it correctly but there is more code to it and that all works, basically it all works ie the insert statement works but i only want the information to be inserted if the user clicks the submit button and my if($submit) aint working

[Weedpacket]

I suggest you go over to the Newbies forum and have a look at the FAQ there; Question One.