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
- 4516 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gaurav
$record = mysql_fetch_array(".........");
$fn = substr($record['firstname'], 0, 2);
$ln = substr($record['lastname'], -2);
$ct = substr($record['city'], 0, 2);
$pc = substr($record['pincode'], -2);
$final = strtoupper($fn.$ln.$ct.$pc);
echo $final;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
how set session expire time in php?
How to open a file for writing?
Tell me what is the difference between the functions strstr() and stristr()?
What is use of echo in php?
Explain the differences between get and post methods?
hi recently i had faced an interview in that they asked me that php have faced the problem of y2k so which one is that year like 2030,2059 not remember exact year anybody will tell me pls?
What is ci framework in php?
What is the difference server side and browser side validation?
What does session start do in php?
Is salary fixed or variable cost?
What can php do?
What is the difference between php and cakephp?
PHP 
