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
- 3488 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
Define object-oriented methodology?
How can you pass a variable by reference?
How can we determine whether a variable is set?
How to return ascii value of character in php?
Why is php used?
What is php string function?
Is php pass by reference or value?
What is the difference between htmlentities and htmlspecialchars in php?
in PHP for pdf which library used?
What are the benefits of using php and mysql?
Tell me what should we do to be able to export data into an excel file?
What is the difference between html and php?
Tell me what is the difference between unset() and unlink()?
What is the difference between abstract class and interface in php?
Which function is used in php to count the total number of rows returned by any query?
