Hi I need to data search by php

[afrojazad]

Hi, I need mysql data searchin by php. But do not complete the data view smothly. so, pls help me.
my data wiew now:
Name: Mobile Blood City Donation date
Sinha 01912266936 A+ Dhaka 9-10-2008
Munna 01917755515 A+ Dhaka 0-0-0000

I want to view my data like this.
Name: Sinha Name: Azad
Mobile: [phone] Mobile: [phone]
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007

Name: Shamim Name: Karim
Mobile: [phone] Mobile: [phone]
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007
Previous>>1 2 3 4 <<Next
you can see my website also.
www.bloodfoundationbd.com
Thanks
Azad

[ashafaaiz]

Hi, I need mysql data searchin by php. But do not complete the data view smothly. so, pls help me.
my data wiew now:
Name: Mobile Blood City Donation date
Sinha 01912266936 A+ Dhaka 9-10-2008
Munna 01917755515 A+ Dhaka 0-0-0000

I want to view my data like this.
Name: Sinha Name: Azad
Mobile: [phone] Mobile: [phone]
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007

Name: Shamim Name: Karim
Mobile: [phone] Mobile: [phone]
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007
Previous>>1 2 3 4 <<Next
you can see my website also.
www.bloodfoundationbd.com
Thanks
Azad

Hi,
I think you have retrieved the data from database. Then no problem, you should design the html form using tables and display whatever you want.

<?
//made database connections here
?>
<form>
<table>
<?
$q1=musql_query("select * from <tablename>");
while($row=mysql_fetch_array($q1))
{
?>
<tr>
<td>Name</td><td><? echo $row['Name']; ?></td>
</tr>
<tr>
<td>Mobile</td><td><? echo $row['Mobile']; ?></td>
</tr>
<tr>
<td>Blood Group</td><td><? echo $row['Bloodgroup']; ?></td>
</tr>
<tr>
<td>City</td><td><? echo $row['City']; ?></td>
</tr>
<tr>
<td>Donation</td><td><? echo $row['Donation']; ?></td>
</tr>
<?
}
?>
</table></form>

i hope it works.

[afrojazad]

Thank you. I do not want to searh result in sigle colum I want 2 colum with limit.

the page like
Name: Name:
Mobile: Mobile:

<<<Previous 1 | 2 | 3 next>>>