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
- 4335 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 |
Do loops php?
What is the default time in seconds for which session data is considered valid?
How do functions work?
Tell me can the value of a constant change during the script's execution?
Explain the purpose of output buffering in php.
What is the tags in PHP is not a valid way to begin and end a PHP code block?
Xplain is it possible to use com component in php?
How can we get the properties (size, type, width, height) of an image using PHP image functions?
How can we optimize or increase the speed of a mysql select query?
What is printf in php?
How many data types are there in php?
How to create the PHP Script to Calculate the Age Using the Inputs Of our Birth date and the Current date?
PHP 
