Hi I need to data search by php
 

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: 01912266936 Mobile: 01712266936
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: 01912266936 Mobile: 01712266936
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

Re: Hi I need to data search by php
 

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.

I need to data search by php
 

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>>>