Newbie Question About Submit Button

[googlit]

Hi, i am wanting to create a simple page with two buttons on, one that says 'start visit', one that says 'end visit', thats the simple bit, here's what i would like the form to do

 

When 'Start Visit' is clicked i would like it to place an entry in the following db:

 

 

I would like it to add the value "start visit" into the value field, automatically insert todays date into the date field and autonatically insert the time (GMT) into the time field.

 

i have made general form before but have no idea on where to start.......

 

any help would be appreciated

[MDCode]

You need to use a form for each button because either will work if they are in the same form.

 

When start visit is pressed just use sql.

 

$sql = "INSERT INTO `table` (value,date,time) VALUES ('start visit', 'CURDATE()', 'date(h:i:s)')";

Edited November 10, 2012 by SocialCloud

[Pikachu2000]

You can have multiple submit buttons in a set of form tags. Just give them different value= attributes.

[Barand]

Define the time column as

 

time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

 

This will insert the current date and time automatically when a new record is added.

As this includes the date the separate date field is redundant.

Edited November 10, 2012 by Barand

[googlit]

Thanks for your help.... problem solved.

 

God i love this forum.... well of to hopefully help some others