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
- 4512 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
Explain include(), include_once, require() and require_once?
What are php filters?
Which array function checks if the particular key exists in the array?
What is cookie and why do we use it?
What is interface? Why it is used?
How would you declare a function that receives one parameter name hello?
What’s the difference between htmlentities() and htmlspecialchars()?
Which php global variable is used for uploading a file?
What is whitespace in php?
What is asort php?
What is the interface in php?
What are the different types of statements that are present in php?
How to assigning a new character in a string using php?
Tell me is it possible to submit a form with a dedicated button?
Explain mixed and callback functions?
