Yes. Here is the code I am using but when I run it all I get is an empty list.
<select name="type" value="Select" size="1">
<?php
$dbh = new SQLite3('hive_manage.db') or die('Unable to open databae');
$sql = "SELECT * FROM hive_type";
$result = $dbh->query($sql);
while ($row = $results->fetchArray($result))
{
$value=$row["type"];
$options.="<OPTION VALUE=\"$value\">".$value;
}
?>
<option>
<?php echo $options; ?>
</option>
</select>
On 5/22/16, 15:35, "Simon Slavin" <sqlite-users-bounces at
mailinglists.sqlite.org on behalf of slavins at bigfraud.org> wrote:
>
>On 22 May 2016, at 11:15pm, Gary Ehrenfeld <gary at ehrenfelds.net> wrote:
>
>> Any suggestions? I am using SQLIte3 and PHP.
>
>Before you try to make a dropdown list with options taken from a SQLite
>database, do you know how to make a dropdown list with fixed text options ?
>
>Simon.
>_______________________________________________
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
