Re: Re: php mysql problem
| From: | chris smith | Date: | Tue, 02 May 2006 12:22:09 +0000 |
| Subject: | Re: Re: php mysql problem | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-235258@lists.php.net to get a copy of this message | ||
On 5/2/06, Ross <ross@aztechost.com> 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.Why do you want to do that? There's no benefit in doing this.. actually it becomes a pain. You'd need to update not only this table but any field in other tables that references this one as well (and if you miss one, you have a completely useless database). -- Postgresql & php tutorials http://www.designmagick.com/