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
- 4304 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
How to calculate the length of a string?
What are the three parts of an http request?
Explain me how failures in execution are handled with include() and require() functions?
How can we display information of a variable and readable by human with php?
How many types of errors in php?
Is php a case sensitive language?
What is the use of post in php?
How to include a file code in different files in php?
How to specify argument default values?
What is the array in php?
How do I know my xampp version?
How to break a file path name into parts?
What is the mysql injection?
What is difference between count or sizeof function in php?
Does php support overloading?
