Database row automically changed when i closed that table and reopened it!

Hai to all,

i created a table in MYSql Database...

And i have added 15 rows in it....

like the following..

asd,
dff,
dfds,
hgh,
...
...
...
...

aaa(15th row)

when i saved that table, closed and reopened it,
the last row(15th) ie the aaa row automatically
changed to the 5th row...
like the following...
asd,
dff,
dfds,
hgh,
aaa,
...
...
...

And the other rows are comes correctly in the order given by me...

i think i want to change the database table properties to come correctly in
the order given by me....

Only the last row gives trouble to me...

since i'm a beginner to mysql i dont know how to do that....

Can any one tell me how to proceed for this?

thanks
senthil.

Hai bartonc,

thanks for ur reply.....

[PHP]mysql_query(conn,"SELECT image FROM imagedb1"); [/PHP]

this is query i have used.

But that problem is not by query...

i think itz just database properties problem...

r u having any idea about this?

thanks
senthil

Hai shashi

thanks for ur reply..

my database is like this...

Expand|Select|Wrap|Line Numbers

1. Name
2. asd
3. dff
4. dfds
5. hgh
6. abc
7. asadf
8. asdf

this is a simple database i had created. And then i had saved that
database and closed...

when i reopened that database the last row that is the 6th row(asdf) changes its
location to the 5th row like the following...

Expand|Select|Wrap|Line Numbers

1. Name
2. asd
3. dff
4. dfds
5. hgh
6. abc
7. asdf
8. asadf

Not for this table row.... when i tried to create lot of rows...
saved, closed and when i reopened the table.... the last row
automatically changes to the 5th row...

i think the i want to check the table properties..

But i dont know..

do u know how to do that?

thanks..
senthil

ya only one field....

first i'm trying for this simple database...
tats y there is only one field

Hai Sashi,

thanks for ur reply....

ur conditions used for me....

i'm working in the field of C++...

Do u know how to convert text data to xml data?

is there any source codes available in the net?

will u plzz help me?

thanks..
senthil