Re: Any method to get primary key matching a given value ?

Hey Ratin, Have you looked into the table column named 'pk' inside table_info? That is where a column is indicated to be a primary key or not. Best, Karl DeSaulniers Design Drumm http://designdrumm.com <http://designdrumm.com/> > On Aug 18, 2016, at 6:51 PM, Ratin <ratin3@gmail.com> wrote: > > Hi Karl, Thanks a lot for your response, I think INFORMATION_SCHEMA is not available for > sqlite database. I had to built up the whole query with php using PRAGMA table_info(tablename), > looking at the pk entry, when its 1, get the column name, and then update the sql statement based on > that. A bit of work, wouldve been much simpler if a method was provided, but oh well .. > > Thanks again > > Ratin > > On Thu, Aug 18, 2016 at 2:53 PM, Karl DeSaulniers <karl@designdrumm.com > <mailto:karl@designdrumm.com>> wrote: > Hi Ratin, > Going to take a stab at this one. > Have you looked into INFORMATION_SCHEMA.COLUMNS for your query? > Might be where you want to look for what you are trying. > Sorry can't help more. > > Best, > > Karl DeSaulniers > Design Drumm > http://designdrumm.com > <http://designdrumm.com/> > > > > > > On Aug 18, 2016, at 1:27 PM, Ratin <ratin3@gmail.com > > <mailto:ratin3@gmail.com>> wrote: > > > > I'm writing the generic get that works on different tables having different > > primary keys but the argument of get is always the primary key , i.e. get > > request is - > > > > get (column name, value) > > > > the value is always the primary key value. > > > > It looks like it would be a pretty standard method but I cant find a method > > like that. Anybody have any clue? > > > > Thanks > > > > Ratin > > > -- > PHP Database Mailing List (http://www.php.net/ > <http://www.php.net/>) > To unsubscribe, visit: http://www.php.net/unsub.php > <http://www.php.net/unsub.php> > >