Interested to Buy Any Domain ? << Click Here >> for more details...
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....
- 2 Answers
- 4421 Views
- I also Faced
- E-Mail Answers
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
Why php script is not running in browser?
When use javascript vs php?
What is the best way to change the key without changing the value of a php array element?
What are the different types of PHP arrays?
What are the special characters you need to escape in double-quoted stings?
Is php dead 2019?
What are the functions to be used to get the image's properties (size, width and height)?
How to make a class in php?
Describe PHP error and logging information?
Require_once(), require(), include(). What is difference between them?
What are interfaces in php?
What is orm in php framework?
Tell me how can we pass the variable through the navigation between the pages?
What are the characteristics of php variables?
Tell me what is the difference between get and post?
