Help with Dropdown list

[Abronsyth]

Alrighty, so I am attempting to put together a dropdown list that will display a user's pets that are "no" for use alternates and level 4...I'm having issues with it.

I am just getting a blank drop-down list. Right now I'm just trying to list all of the user's pets.

Here's the code I'm attempting....

$stmt = $mysidia->db->select("owned_adoptables", array("name"), "owner = '{$mysidia->input->get("user")}'");
$name = $stmt->fetchColumn();
$formExample = new Form("exampleform", "page_to_send_to_here", "post");
$exampleDropdown = new DropdownList("solarList");
$exampleDropdown->add(new Option("{$name}", "{$name}"));
$formExample->add($exampleDropdown);
$formExample->add(new Button("Click Me", "submit", "submit"));
$document->add($formExample);

This is my first time trying to work with dropdown lists in Mysidia, so I am very lost. If anyone could help I'd really appreciate it.

 

[Dinocanid]

To display all of a user's pets in a dropdown, there's this code

$stmt = $mysidia->db->select("owned_adoptables", array("name", "aid"), "owner = '{$mysidia->user->username}'");

You can narrow down which adoptables are available in the dropdown, in your case by level and alternates, with something like this:

$stmt = $mysidia->db->select("owned_adoptables", array("name", "aid"), "owner = '{$mysidia->user->username}' AND level >= '4' AND usealternates = 'no'");

It would also select adoptables who have a level higher than 4, since it uses ">=", but you could change it to just "=" if you only wanted level 4 pets to appear.

 

[Abronsyth]

Thank you!

But I am still not sure how to actually get it to show that data in the drop down as options :/

By this I mean I'm not sure what to put here;

$exampleDropdown->add(new Option("pet name?", "aid?"));

 

[Dinocanid]

Maybe this?:

$options = $mysidia->db->fetchList($stmt);
$exampleDropdown->fill($options);

I'm going off of this here, maybe it can help?

 

[Abronsyth]

Thank you for the link, that is helpful.

Hello!!
It is working

Thank you for all of your help, Dinocanid <3