Publisher Forms posting to SQL

[Pablo]

This question will pertain to any who are familiar with php and SQL and using
it with Publisher.

I am currently using Publisher to build a site using an SQL database. Front
Page's extensive options seem to be a detriment at this time, so I'm sticking
with Publisher. I can add php code to the pages Publisher creates, and have
the forms I created with Publisher work for the most part, however, I have
one particular page where I have a USERNAME field, a PASSWORD field, and a
SUBMIT button.

In the Properties of the form, I have the Data Retrieval Information field
pointing to the .php file on my server it needs to. Now, everything seems
fine in terms of the options in the form, except when I enter a practice
Username and Password and click Submit, the form is gaining access to the
database NOT with the info I provided, I guess it's using the info in the
..php file on the SQL server.

When I click submit, shouldn't Publisher Submit the Username and Password I
entered in the form? The Username I use is valid with proper rights. Any
ideas? Any clarification on my part? Thanks in advance.

 

[Mike Koewler]

Pablo,

What script are you using to handle your form? I use Soupermail which
can append a DB (not that I need to) but I believe it is a two-step
process - I get the info in an e-mail and it also gets appended to the DB.

Mike