Is it possible to do 'SELECT FROM table WHERE "userinput from dropdown selection" = :id;

you have it backwards. you aren't looking to substitute a value for the id you've circled. that's the name of the column, it stays as it is.

it's not SELECT FROM table WHERE "userinput from dropdown selection" = :id

it's SELECT FROM table WHERE id = "userinput from dropdown selection"

the use of :id as a parameter that you are binding with ":id" => $id gets you most of the way there.

now you just need to populate $id with the value of the dropdown in the submitted form.

if you dropdown is <select name="id" I think I would expect your code to work as it is. If it doesnt I must be missing something. It's hard to tell without the form. Otherwise change to $id = $_POST['nameofyourdropdown'];

/r/PHPhelp Thread