Page 1 of 1

How to retrive feildes from databse

Posted: Wed Oct 15, 2008 12:30 am
by swamyt
Hello,

I have a five fields in database(mysql) .Each field is having a 5 values .I want retrieve all values from database .But if i use while loop i got output with all values otherwise only one value is coming. so i want all values from database without while loop .

Please Help me

Thanks and Regards

Swamy

Re: How to retrive feildes from databse

Posted: Wed Oct 15, 2008 12:44 am
by 0perand
So you are saying you have a table with 5 rows and 5 columns?

EX:

First Name | Last Name | Phone | UID | PASSWORD

ROW1: Dirk | Diggler | 555 | 1 | no
ROW2: Kirk | Diggler | 555 | 2 | no
ROW3: Nirk | Diggler | 555 | 3 | no
ROW4: Yirk | Diggler | 555 | 4 | no
ROW5: Zirk | Diggler | 555 | 5 | no

Re: How to retrive feildes from databse

Posted: Wed Oct 15, 2008 1:21 am
by swamyt
my field names are First Name, Last Name , User Name

First Name field values = Harish , swamy , Naresh

Last Name field values = Tha, kdkdf , fjdsokf

User Name field values = Harish , swamy , Naresh

i want retrieve these values