# MySQL table behaving badly

**URL:** https://forum.kirupa.com/t/mysql-table-behaving-badly/161983
**Category:** programming
**Created:** [September 8, 2005, 6:20pm UTC](https://forum.kirupa.com/t/mysql-table-behaving-badly/161983 "2005-09-08T18:20:52Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![mlk](https://avatars.discourse-cdn.com/v4/letter/m/e56c9b/32.png) [@mlk](https://forum.kirupa.com/u/mlk)
#### Post date: [September 8, 2005, 6:20pm UTC](https://forum.kirupa.com/t/mysql-table-behaving-badly/161983/1 "2005-09-08T18:20:52Z")

</div>

I would probably know what’s wrong with this had I a tad more experience, but here’s my problem:

![](http://forum.kirupa.com/uploads/kirupa/1792/328dc7389fc846e8.gif)

As you can see, some of the inserts in the table _manage_ to get inserted in random places. I assign an ID on each insert (auto increment), but does anyone know why the inserts just place themselves wherever they want ?

(by the way I manually deleted some entries)

I managed to sort by ID in phpMyAdmin, but it still puzzles me =)

I’ll post the insert code, but nothing’s too special with it

mlk