Welcome to WebmasterWorld Guest from 54.144.246.252

Forum Moderators: phranque

simple database query

eg. how do I integrate one!

   
3:08 pm on Jul 10, 2002 (gmt 0)

10+ Year Member



I'm doing a site which has a search for event page which has 2 dropdowns - location & date. When the submit button is clicked I need it to access the database and return the results.

I dont expect someone to explain it to me here, I am after links to tutorials etc. Databases have always been something of a mystery to me...

Thanks in advance

3:21 pm on Jul 10, 2002 (gmt 0)

10+ Year Member



Well the solution will vary depending on which scripting language and database you're using...

what are you working with?

3:31 pm on Jul 10, 2002 (gmt 0)

10+ Year Member



html form with an access database.
3:40 pm on Jul 10, 2002 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



it depends on the language you have available. You could also check in the respective forums here.

Perl, PHP, and Python Scripting [webmasterworld.com]
Microsoft .NET and Related Technologies [webmasterworld.com]

or here are a couple
[php.net...]
[phpbuilder.com...]
[mysql.com...]

3:54 pm on Jul 10, 2002 (gmt 0)

10+ Year Member



Thanks for that. Sorry to be so vague!
4:07 pm on Jul 10, 2002 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



no problem, that is what we're here for. If you figure out what languages are available to you from your host then post in the appropriate one of the two above forums you will get all the resident experts for that particular language.

It will make your life a little easier. Get a little more info and we can be more helpful.

good luck allybongo ;), feel free to ask any questions that come up. (there will be tons)

12:21 am on Jul 11, 2002 (gmt 0)

10+ Year Member



hi, I had the same problem and decided to use an access database with an ADO connection. It really is a very simple thing to do and will take you about 2-3 days to get to grips with. There is one site I would swear by its called w3 schools. I suggest learning first asp then ADO then SQL the site will help you with all of these and its all free. www.w3schools.com
4:37 am on Jul 11, 2002 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



I would agree with the above post. With ASP and Access you can be up and functional in a day or two. Faster if you have some experience.

I've used ASP with AS/400 databases and adore the ease of use.

8:28 am on Jul 12, 2002 (gmt 0)

10+ Year Member


I agree with uk_dokey about w3schools - very useful. For specific technical ASP queries I'd go to http://www.4guysfromrolla.com.

If you go down the ASP route http://www.brinkster.com offers free ASP web hosting and has a codebank and forums with probably most of the info you'll need.

Neil

8:32 am on Jul 12, 2002 (gmt 0)

10+ Year Member



thanks for all that guys, although I think I'll have gone insane before I understand it all!
4:04 pm on Jul 12, 2002 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



anytime allybongo

ecardiff,
you might want to take a look at TOS #14 [webmasterworld.com] sig url's aren't allowed

 

Featured Threads

Hot Threads This Week

Hot Threads This Month