MySQL Help / Expert
 

Hi,

I am new to SQL and have succesfully got it running so I suppose that's a start :)

I need to do the following :

1.capture values passed via an URL

2.add data to table1 containing 2 fields

3.perform query that lookup's data in table 2 based on content of table1's field1

If anybody can help it'd be appreciated ! Alternatively, if you can forward me any online resources which will help me.

Thanks !

Jai

Hello

What scripting language are you going to use?

For example if you are using ASP, you can say var x = Request("urlparameter") to retrieve the value from a URL.

Steve.

1. Get a book on SQL - this will teach you the commands you use to manipulate databases (eg. INSERT, UPDATE, SELECT, etc)
2. Get a book on whatever server side scripting language you're going to use(eg. PHP, ColdFusion, ASP, etc) - this language will offer many commands you can put in your web pages to manipulate databases.

As Boxst says, the answers you seek are dependant on what scripting language you intend to use. They all have their own particular way of achieving what you're looking for.

I would firstly take a look at www.w3schools.com. It is a very good site for beginners.

And also take a look at some forums:
forums.devshed.com (deals with everthing you can think of to do with websites and programming)
www.aspfree.com (as you can tell from the URL deals with all ASP)

and if you are still stuck after that send me a PM or email and I will try and help you out.