Forms and DBs

[ironmunk]

hi, is there a way to use data from a HTML form and use that to modify data in a DB?

Heres my situation.

I have a form setup for an event.
The user selects which event they want to go to (in a form)
The form then goes to the DB and check to see if #ofTix > 0
If it is, the user continues to the next screen and the DB is modified.

I'm new to this web programming thing, so any references or help would be appreciated.

 

[JoJoH]

Hi,

You need some type of dynamic scripting language such as VBScript and SQL to accomplish what you want. You will need to write SQL to check if the #oftix for that particular performance is greater >0 if the result is yes than you will need VBScript and SQL to update the database accordingly.

An excellent SQL tutorial could be found here:

http://www.w3schools.com/sql/default.asp

An excellent VBScript tutorial could be found here:

http://www.w3schools.com/vbscript/default.asp

Hope this helps!


JoJoH

http://www.jadeboutique.com

 

[ironmunk]

thx for the reply.

I'll try to program something quick.

I have exprience with SQL and VB just none with integerate it with webpages.

 

[tviman]

To add to JoJoH's reply, here's the scenario you want to follow:

1. user fills out form and submits
2. your script reads the form data
3. based on user request, open a connection to the DB
4. run SQL against DB (select something from db where....)
5. test results from query (don't forget to test for null responses)
6. if #ofTix > 0, open new page
7. if #ofTix = 0, open another page


There's always a better way. The fun is trying to find it!