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
- 4432 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 to count how many sundays in month?
What is the maximum size of a file that can be uploaded using PHP and how can we change this?
Explain mysql_error().
What is difference between include,require,include_once and require_once()?
Is php an object or array?
What is the difference between characters and #?
can anyone explain about stored procedure,Triggers and transaction in php?
Why do we use inheritance in php?
What does csrf token mean?
Do you know is it possible to extend the execution time of a php script?
equivalent code for the following c program in php void main() { int i=5;printf("%d",i); }
Why do we show php code in browser?
PHP 
