How to detect primary key in a table using PHP

[ulag]

I use mysql. I want to know what fields are primary or unique keys? I need to find by PHP. Please help me.

Thanks.

ulag

 

[mtlintz]

This link

http://www.php.net/manual/en/function.mysql-field-type.php

shows how to do something like that

 

[DumTech]

There's probably a simpler way to do it, but this function works ok for me.

function get_primkey($table) {
    $result = mysql_list_fields($dbname,$table);
    if (!$result) {
        return false;
    }
    while ($field = mysql_fetch_field($result)) {
        if ($field->primary_key) {
            $pri_key = $field->name;
            return $pri_key;
        }
    }
}

Matt
matt@paperlove.org
If I can help, I will.