Re: [PHP-DB] Filling a dropbox on form

[Alan Hale]

Alan Hale wrote:

> http://www.devshed.com/Server_Side/MySQL/JS_Arrays/
>
> I found it difficult to understand what was going on because the code
> example is embedded in the rest of a complex page layout. I also think there
> are errors in the code, which I've only partly sorted out (I'm a Javascript
> novice).

Just an update - I've realised this breaks with the example data given (in the
"extranet" database) - there is a person_id entry (30) in the person_skills
table which has no corresponding row in the personnel table. Once this is fixed
the code works fine.

Alan Hale


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Filling a dropbox on form

[Alan Hale]

Howard Picken wrote:

> Running Freebsd, Apache, MySQL and Php4.
>
> Does any one know of way to fill a dropbox that
> reduces the list of items as you type in more
> info.

I've looked at some scripts but not yet found something entirely
satisfactory. Andrew King's script at www.webreference.com does a very nice
job, but seems to depend on using two forms - a pain if you want to post all
your data with one Submit.

I've also played with this one:

http://www.devshed.com/Server_Side/MySQL/JS_Arrays/

I found it difficult to understand what was going on because the code
example is embedded in the rest of a complex page layout. I also think there
are errors in the code, which I've only partly sorted out (I'm a Javascript
novice).

Good luck! If you find anything better, let us know!

Alan Hale


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Filling a dropbox on form

[Paul Burney]

on 5/18/01 8:16 PM, Howard Picken at [EMAIL PROTECTED] wrote:

> Does any one know of way to fill a dropbox that
> reduces the list of items as you type in more
> info.
> 
> I have a dropbox that fills with data from
> a MySQL db and it wrks fine.  Except that now
> the list has grown to more then 300 uniquie items
> it's a pain to select from it.

It can't really be done in PHP because PHP is server-side.  You'll need a
client-side language (e.g., JavaScript) to do it.  They may have something
for this on:



Other than that, you could have the user do a limiting search on the DB for
the item first, and then make the drop box from that.

HTH,

Paul Burney
http://paulburney.com/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]