Hi,

I am new to this forum and absolutely new to php and mysql.

I have managed to create a extremely simple html form which saves the data to a small mysql database.

Please be aware, this will look very childish to some experts out there.

This is what happens. I have a html form, a database and a input.php form. the input.php for gets the details from the html form and saves them to the database. I can do this and only this. I would love to be able to delete and edit records, but I can't do it as I don't know how to use php. Its taken me 2 weeks sorting the database out.

what i would like the form to do is, when submit form is clicked, the input.php page loads, currently I have managed to put a message on there. what I would like is a button, which when pressed, takes the user back to the form, which has been reset.

OR, is there a way to stay on the same html page after clicking submit??

if anybody can help, please do.

thanks

Yes, put the php code to collect the data on the same page as the form.

Originally Posted by chrishirst

Yes, put the php code to collect the data on the same page as the form.

okay, sounds simple enough. Do I just copy and paste it or would I need to change anything?

Originally Posted by chrishirst

Yes, put the php code to collect the data on the same page as the form.

Yes, at it's very simplest you basically do this:

if form has been submitted
   check the sent form data
   add it to the database
end if

show form here

And the action attribute of the form should point to itself.
I'll let you work out the actual code yourself, since that's a good way of learning.
I had alot of help from tizag.com and w3schools.com when I was new to php and MySQL, you might want to check them out.