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....
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 |
What are the limitations or drawbacks of PHP ?
What is use of isset function in php?
What are the different types of php variables?
What does sign mean php?
What are session variables in php?
Explain me what is sql injection?
for image work which library?
What is the use of htmlspecialchars in php?
Tell me what is the main difference between php 4 and php 5?
What is the difference between php traits vs interfaces?
What is the difference between rest and soap?
what type of images that the PHP version supports