Question

I want to retrun the column name from sql database in php after certain conditions. For example the column is Z,H,Y,J and the value for each column is FFA,1,0,1. First I want to compare my input(array) with Z if my input is equal to Z I want to search any column with 1 and retun the column name by array.

Answer 1

Answer:

It should be noted that the primary_key member variable is only set to 1 if the primary key on the table is only on that 1 field. If you have a table that has a multiple column primary key, then you will not get what you might expect.

For example:
CREATE TABLE `line_item_table` (
`liForeignKey1` int(11) unsigned not null,
`liForeignKey2` int(11) unsigned not null,
PRIMARY KEY (`liForeignKey1`, `liForeignKey2`)
) ENGINE=MyISAM;

While you might expect that primary_key == 1 for both columns; var_dump() will show you that you get the following for both fields:
["primary_key"]=>int(0)

This is as of PHP 5.2.13 and MySQL 5.0.51