Insert From Form

[Sharif]

I am trying to setup ONE PAGE that by itself, will insert somethings into a sql table.
The fields that I need to input are:
- Title (text)
- Author (drop down)
- Email
- News (text)

I also need to the date and time the data was submitted at (a timestamp). I also want to do this: If user selects Author 1 from the author drop down menu, then the email field will be [e-mail], for author 2 email will be [e-mail] and so on, So the email field will be input based on the selected author. How can I do this?

[kevinsequeira]

on form_page.php do the form code

on form_page_action.php write the code to accept the form and collect the values

form_page_action.php

// get all values

$date_submitted = date("Y-m-d H:i:s");

//now from the author name in the dropdown get the author name say $author.

// insert into datbase all the values

// get who to mail to and use it in the mail function

$mail_to = $author."@domain.com"
// use mail() function to mail the author
http://www.php.net/manual/function.mail.php

this should get you started. hope you dont expect us to write the whole code for you

reg
kevin

[Sharif]

Well first off, the form won't be emailing anyone. It will be INSERTING the email address of the author into a field. Second, I know nothing about what I am trying to do. Is there any online tutorials or places that will explain what I need to use?

[kevinsequeira]

oh PARDON ME 😃, if the form doesnt mail anything to anyone use this

form_page_action.php
// get all values
$date_submitted = date("Y-m-d H:i:s");
//now from the author name in the dropdown get the author name say $author.

$email = $author."@domain.com"

// insert into datbase all the values

but if you have no idea what you're doing ignore everything that ive typed and go to the tutorial here

http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

reg
kevin