form data return

[kelly2ds]

1. Form populates database with no problem.
2. Can retrieve data with no problem.
3. Don't want users to log in or give the form an id number. Trying to use an auto-increment id number.
4. Need the data entered into the form to be the record that is returned, but the data coming back is from the first record only.
5. Session variable issue? Or can I not use an auto-increment variable for a join?
6. Have many users keying in a simple form. Want them to key in, and then preview their responses for an edit/update, then post.
argh. I should know this.
Kelly

[Newsgroup_User]

Need to see your form processing script! 8)

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"kelly2ds" <webforumsuser@macromedia.com> wrote in message
news:fkv36u$mrh$1@forums.macromedia.com...
> 1. Form populates database with no problem.
> 2. Can retrieve data with no problem.
> 3. Don't want users to log in or give the form an id number. Trying to use
> an
> auto-increment id number.
> 4. Need the data entered into the form to be the record that is returned,
> but
> the data coming back is from the first record only.
> 5. Session variable issue? Or can I not use an auto-increment variable for
> a
> join?
> 6. Have many users keying in a simple form. Want them to key in, and then
> preview their responses for an edit/update, then post.
> argh. I should know this.
> Kelly
>

[kelly2ds]

Thank you for taking a look. I went out to look and see yes it's a form processing issue. Here's what I'm looking to do.
1. single form, single table
2. user enters and submits
3. user sees what they entered as a quick review and then has the option to "post" or edit
4. The primary key id is auto-increment. I don't want the user to need to key in a user id or password, etc.

My file lacks a good processing script, here is how it grabs data from the database, that's embarrassingly enough all I have. And, a quick question, when I was looking around I saw several processing scripts for sale. I try to keep code minimal, do you use or have you had success with one of these processing script products?
Thank you. Kelly

mysql_select_db($database_usa, $usa);
$query_rs_check_art_media_usa = "SELECT * FROM art_media";
$rs_check_art_media_usa = mysql_query($query_rs_check_art_media_usa, $usa) or die(mysql_error());
$row_rs_check_art_media_usa = mysql_fetch_assoc($rs_check_art_media_usa);
$totalRows_rs_check_art_media_usa = mysql_num_rows($rs_check_art_media_usa);

[kelly2ds]

<form name="form1" id="form1" method="POST" action="<?php echo $editFormAction; ?>">
forgot this.