php - Values not being returned -

php - Values not being returned -

i'm using function retrieve product info based on 2 parameters $request , $id. request processed , right database field returned used in query. info isn't beingness returned $request string is.

public function productinformation($request,$id) { switch($request) { case "id": $request = "id"; break; case "desc": $request = "description"; break; case "slug": $request = "slug"; break; case "parent": $request = "parent"; break; case "thumb": $request = "thumb_url"; break; case "image": $request = "image_url"; break; case "visible": $request = "visibility"; break; case "time": $request = "stamp"; break; } $connect = new dbconnect; $connect->query("select :request products id = :id"); $connect->bind(":request",$request); $connect->bind(":id",$id); $query = $connect->single(); homecoming $query[$request]; }

so if $request = "desc", return $query[$request] homecoming description string? i'm calling right array key i'm not sure issue is?

you can't bind column names (or table names), info values.... i.e. can't bind $request it's column name

$connect->query(sprint("select %s products id = :id", $request)); $connect->bind(":id",$id);

php mysql pdo