Hi thank you ...... My database is retrieve from another automation tool. My question is .. Every link field should have 1 c='some value' I want to get that value... But i dont kno the position of c=. That field having only one 'c=' Can you give me a query....
cdg1111us <[EMAIL PROTECTED]> wrote: Hi, it's a little hard to understand your question, but I think you want to know how to see what "c" is in each link? Like many things in programming, there are many ways you could go about doing this, but I'll give you two ways: 1.) If the "Link" field is made by you previously, create several more fields in the database table to hold the "c" value and other values that are part of the link and then make the link out of those values when needed. After concatenating several important pieces of data into one database field, it's hard to get it out again... 2.) If these links are how you receive the data, then you will need to do some sort of string splitting (by using substr or preg_split) in PHP or another programming language. --- In [email protected], Arun karthikeyan <[EMAIL PROTECTED]> wrote: > > Hi there, > In my table having 4 fields.That is > _id__|Link_________________ datano___________name| > 1 | jsg/jm/c=us&js |Mar 24|__________Katik > 2 | jsg/jm/c=eu&js |Mar 24|__________Katik > 32 | jsg/jm/c=us&js |Mar 25|__________Katik > 12 | jsg/jm/c=bs&js |Mar 24|__________Katik > 7 | jsg/jm/c=us&js |Mar 27|__________Katik > > My output will be....... > > us link Count > jsg/jm/c=us&js 3 > > jsg/jm/c=bs&js 1 > > jsg/jm/c=eu&js 1 > > That it ... can i check that 'c=' value that c in place of anywhere in url. > > > > > > > > > > -With love > SM.ARUNKARTIKAYAN > > > > > > > > > > > --------------------------------- > Sucker-punch spam with award-winning protection. > Try the free Yahoo! Mail Beta. > > [Non-text portions of this message have been removed] > -With love SM.ARUNKARTIKAYAN --------------------------------- Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A. [Non-text portions of this message have been removed]
