Re: [PHP3] DB delete problem !
| From: | (Richard Lynch) | Date: | Sat, 10 Jun 2000 00:29:44 +0000 |
| Subject: | Re: [PHP3] DB delete problem ! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-1518@lists.php.net to get a copy of this message | ||
In article <001e01bfce07$f45de3b0$5a1878d2@genitaiji>,
seojuyung@channeli.net ("Seojuyung") wrote:
> ------=_NextPart_000_001B_01BFCE53.61BA7400
> Content-Type: text/plain;
> charset="euc-kr"
> Content-Transfer-Encoding: quoted-printable
>
> Hello ~
>
> I have a problem with dealing DB deleting.
>
> Now let us proceed to the main subject ,=20
>
> I have a DB table consist of 5 members(field name is 'uid').
>
> 'uid' order is 1,2,3,4,5.
>
> I deleted number 3 member.
>
> then I sorted it in regular order, 1,2,3,4.
>
> and I inserted another member.
>
> but, the 'uid' field became 1,2,5,3,4 contrary to my expectations =
> 1,2,3,4,5.
>
> How can I make this field to 1,2,3,4,5 as I anticipated ?
Use "select uid from members order by uid"
--
Richard Lynch | If this was worth $$$ to you, buy a CD
US Customer Support Director | from one of the artists listed here:
Zend Technologies USA | http://www.L-I-E.com/artists.htm
http://www.zend.com | (this has nothing to do with Zend,
duh!)