使用php在MYSQL中根据用户输入检索列名

Question

Currently i am doing a PHP GET and getting values after clicking the submit button.

I got the values out from the submit button but I dont know how to reference them to the values in column.

For example, after clicking the submit button, I get the value 1.

Inside my database i have 3 columns

Col 1 Col 2 Col 3

 2   3  1

How do i get the COLUMN name by just having the value itself? Thank you so much!

Answer 1

Ugly/silly, but would do what you want:

Query:

SELECT * FROM yourtable WHERE 1 in (col1, col2, col3, ... ,colN)

and then manually pick out the value in client code:

$row = mysql_fetch_assoc($result);
$matches = array_search(1, $row);
var_dump($matches);

You can't get away from listing all of the columns in the query, because there's no WHERE x IN (*)-type construct.