Jump to content

[SOLVED] find primary key for roll back function


benjaminbeazy

Recommended Posts

hey guys, trying to write a rollback function such as this...

 

function rollback($array){

  foreach($array as $var => $val){

    query('DELETE FROM $var WHERE id = $val');

  }

}

 

i know that syntax isn't quite right and some error checking and what not is required, but you get the idea. anyway, the problem is that the primary key isn't always named "id". in fact, rarely is it named id. is there an easy way of finding the primary key?

 

something like this maybe...

 

DELETE FROM $var WHERE (PRIMARY_KEY) = '$val'

 

???

 

any input will be helpful. thanks in advance!  :)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.