Exactly - I don't think you really understand how a relational database
works. The ids are retained as they may relate to records in another table.
Internal sorting order is of no relevance at the application level. I think
you need to rethink your design a little.
On 02/05/06, T.Lensselink <admin@xxxxxxxxxx> wrote:
> This is my database now...I will use the item_id for the order but what
if
> I
> want to change item_id 3 to item id 1? How can I push all the items down
> one
> place? How can I delete any gaps when items are deleted.
>
>
> CREATE TABLE `board_papers` (
> `id` int(4) NOT NULL auto_increment,
> `doc_date` varchar(10) NOT NULL default '0000-00-00',
> `article_type` enum('agenda','minutes','paper') NOT NULL default
> 'agenda',
> `fileName` varchar(50) NOT NULL default '',
> `fileSize` int(4) NOT NULL default '0',
> `fileType` varchar(50) NOT NULL default '',
> `content` blob NOT NULL,
> `item_id` int(10) default NULL,
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
>
>
>
>
>
> ""Ross"" <ross@xxxxxxxxxxxxx> wrote in message
> news:6C.5F.05123.70D27544@xxxxxxxxxxxxxxx
>>
>> Just say I have a db
>>
>> CREATE TABLE `mytable` (
>> `id` int(4) NOT NULL auto_increment,
>> `fileName` varchar(50) NOT NULL default '',
>> PRIMARY KEY (`id`)
>> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
>>
>>
>> when I add items they go id 1,2,3 etc. Whn I delete them gaps appear.
1,
>> 3, 7. I need to know
>>
>> (a) when items are removed how can I sort the database to all the gaps
>> are
>> take out 1, 3, 7 becomes 1,2,3
>>
>> (b) allow the ids to be changed so the items can change position in the
>> list. If I change id 3 to id 1 then everything else shifts down.
>>
>> If anyone has seen the amazon dvd rental list where you can swap dvd to
>> the top of the list and delete this is what I am trying to achive with
>> php/mysql.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Really can't imagine why you wanna do something like this. What's the use
in reordering a database. It's just a database. you can sort it in any way
you like.. gaps or not.. Sounds to me the sorting is only done on screen.
This is pretty easy done with PHP not in the database itself.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
http://www.web-buddha.co.uk
dynamic web programming from Reigate, Surrey UK (php, mysql, xhtml, css)
look out for project karma, our new venture, coming soon!
