RE: Drop Down list

2001-06-20 Thread Lee Goddard
> Hello group, > I have really tried to to populate a dropdown list with values from a database. In >the past I've worked around this > problem and it's not been an issue. But now, the time has come to s%$t or get off >the pot. > > Has anyone a little advice on this procedure? > > Let's say I

RE: Drop Down list

2001-06-20 Thread Purcell, Scott
Hello Mark, That should be pretty simple, actually I do it, and probably have a code sample somewhere here... Evidently you are doing a cgi, so I would at the beginning of the cgi call for a connect to your db. Then start your HTML, then make your select on the page. print qq{}; now get your quer

RE: Drop Down list

2001-06-20 Thread stanley . g . martin
If you've done all the up front work with DBI and done your query, you just need to get the results into your list like this: while ($row = $sth->fetchrow_array) { print "fetchrow_array()) { $value1 = $data[0]; $value2 = $data[1]; } What would be the best way to create something