Can you insert at a specific location in PHP/MYSQL?
I was wondering if there was a quick and easy way of inserting a row at a specific location into the database?
The thing that gets me is every time I fool around with MySQL statements it usually ends in epic disaster:D, though the wording make sense it usually doesn't work for me. I am going to search around in the MySQL 5.x Reference Manual for the solution, but I thought I would come here if any php guru could answer my question. I have a feeling that I will have to do this by using an array, for I have programmed in other languages. However, it would be quicker using the MySQL.
$stmt = $db->prepare("INSERT INTO pages (position, blog_name, content) VALUES (?,?,?)");
P.S. I hope I made this clear enough.