get primary key of row

[Gasolene]

I have a query that returns rows from a table.

The query may or may not contain the primary key in the select statement

I need the primary key name and value for each row

how do i get these?

thnx,

$query = mysql_query( 'select * from table' ); // some unknown query

while( $row = mysql_fetch_array )
{
  $i=0
  while($i < mysql_num_fields( $query ))
  {
    // i need prim_key name and value of $row
    echo $row[$i++] ;
  }

}

[paulnaj]

Hi,

You can use mysql_fetch_field() to find out the pk, if the table has one.

Paul

[Gasolene]

mysql_fetch_field expects a column number and only returns results that are in the result set.

(unless I misunderstood how to use mysql_fetch_field)

not all queries will have primary key ex:

mysql_query( "select foo as MyFoo, bar from mytable where x > 4 order by y" )

I need something that will tell me the primary key regardless of whether or not it is in the original query.

[paulnaj]

Just put the pk in the field list!

[Gasolene]

if by field list you mean the sql statement, I can't do that.

this script has to work with unknown sql select statements.

it must work with sql queries that do not have the primary key in the select statement.