Kindly view the code:

Code:
<?php
include("../db.php");
$result = mysql_query("SELECT * FROM accounts WHERE id LIKE 7");
while($r=mysql_fetch_array($result))								{										$clientname=$r['name'];								$date=$r['date'];									$clentid=$r['id'];
$data1=$r['d1'];
$data2=$r['d2'];
$data3=$r['d3'];
$data4=$r['d4'];
$data5=$r['d5'];
$data6=$r['d6'];
...