LOOK UP Primary keys in a table and get the keys in assoc array

[sribhaskar]

I am trying to look up a table and get the primary keys of the table into an assoc array , the below code is working for 1 primary key but its not working for  more than 1 primary keys in a table.

 

Could any one please help  me in this. , I am a beginner in php.

 

 

 

$getPrimaryKeys="SELECT k.COLUMN_NAME FROM information_schema.table_constraints t LEFT JOIN information_schema.key_column_usage k

USING(constraint_name,table_schema,table_name) WHERE t.constraint_type='PRIMARY KEY'    AND t.table_schema='".$schemaname."' AND t.table_name='".$table."';";

$results=mysql_query($getPrimaryKeys);

$priKeys=mysql_fetch_assoc($results)

<pre>

print_r($priKeys);

</pre>

[requinix]

...There is only one primary key in a table. You mean a composite key? A primary key with more than one column?

[sribhaskar]

yes , the above code is not working if the table has composite keys 

[requinix]

It works. Did you know that it will return multiple rows?

[sribhaskar]

yes the query is returning multiple rows

[requinix]

Then how is it not working?

[Q695]

do a while loop with the ."$priKeys=mysql_fetch_assoc($results)"