I corrected the results to result and everything works. Thank for seeing that. I feel really stupid right now.
On 5/22/16, 15:51, "Simon Slavin" <sqlite-users-bounces at mailinglists.sqlite.org on behalf of slavins at bigfraud.org> wrote: > >On 22 May 2016, at 11:46pm, Gary Ehrenfeld <gary at ehrenfelds.net> wrote: > >> Yes. Here is the code I am using but when I run it all I get is an empty >> list. > >Just as a test, replace your code which makes the dropdown list with code >which just shows the options on the display: > >"<p>".$value."</p>" > >Get that working first, then worry about a dropdown list. > >> $result = $dbh->query($sql); >> while ($row = $results->fetchArray($result)) > >That looks wrong. Try to distinguish between your two variables $result and >$results . > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users