how to retrieve from database..... this format (PRMRMDU402).
firstname= prabhu, lastname=kumar, city=madurai,
pincode=624402....
i want first name first two letters and last name last two
letters ... city first two letters ... pin code last three
letters....
Answer Posted / ajit
SELECT SUBSTRING(`firstname`,1,2) as 'firstname',SUBSTRING
(`lastname`,-2) as 'lastname',SUBSTRING(`city`,1,2) as
'city',SUBSTRING(`pincode`,-3) as 'pincode' FROM
`user_info` WHERE 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is variable give example?
What is self in php?
Is python easier than php?
What is php and how do you use it?
How do I know my xampp version?
What is the function of trim?
What is the purpose of php?
What is the use of callback in php?
Which php framework is best?
What is array and function?
What is variable function php?
Is jquery better than javascript?
What is xss and csrf?
Is apache needed for php?
What are Routines?