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....

PHP Code:

$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

PHP 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:

PHP Code:

$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;

PHP Code:

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


[Dinocanid]

Maybe this?:

PHP Code:

$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 :D

Thank you for all of your help, Dinocanid <3