Jump to content


Photo

Selection Box


  • Please log in to reply
4 replies to this topic

#1 scottybwoy

scottybwoy
  • Members
  • PipPipPip
  • Advanced Member
  • 532 posts
  • LocationUK

Posted 22 August 2006 - 09:53 AM

Is it possible to have a selection box with values from a table.  But when the form starts it has an empty value, then the user can type into it and as it does it finds the record that matches the user input?

If so what method must I use?

#2 willpower

willpower
  • Members
  • PipPipPip
  • Advanced Member
  • 296 posts
  • LocationWarrington, Cheshire, UK

Posted 22 August 2006 - 10:01 AM

This can be done...but with javascript and in this case AJAX where you create a 'behind the scenes' link with the database using the DOM object.

But I am afraid...I cant do it

Search google for ajax applications and tutorials. 
Wait...I've got it...Bollocks, it's gone again!

If at first you don't succeed....stop using ASP and get onto PHP

#3 scottybwoy

scottybwoy
  • Members
  • PipPipPip
  • Advanced Member
  • 532 posts
  • LocationUK

Posted 22 August 2006 - 12:06 PM

Cheers for the pointer.  I have heard of AJAX but didn't reaslise how it was needed.  Now I have to learn some JavaScript and XLM too, damn, was just learnin php first, but it'll all be good under the belt.

#4 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 22 August 2006 - 12:15 PM

www.ajaxfreaks.com

That is a sister-site to phpfreaks.com and should help you out quite a bit.  For what we're talking about here, you won't need any XML unless you're storing the data in XML files instead of a database.

Info: PHP Manual


#5 scottybwoy

scottybwoy
  • Members
  • PipPipPip
  • Advanced Member
  • 532 posts
  • LocationUK

Posted 22 August 2006 - 01:33 PM

Thanks ober, I will be using a database.

While were here on the subject tho, will I have to use this If for instance the customer name entered does not exist can it still put the details into the form but not enter it into the database so that the other fields can be filled in manually by the user, before using a submit to Insert it into the database?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users