@AL7X7 To be honest it doesn't make any difference if there is a gap in the primary key column (newsID in this case), in this case it wouldn't be displayed anywhere on the page so I personally wouldn't bother tidying it up. However, if you still want to:using phpmyadmin to enter it, just enter 4 as the newsID. If using web forms to enter the record I would run a query that returns the record with the highest ID, then increments it by 1 and sets the ID to that. Let me know if you want sample code
@AL7X7 To be honest it doesn't make any difference if there is a gap in the primary key column (newsID in this case), in this case it wouldn't be displayed anywhere on the page so I personally wouldn't bother tidying it up. However, if you still want to:using phpmyadmin to enter it, just enter 4 as the newsID. If using web forms to enter the record I would run a query that returns the record with the highest ID, then increments it by 1 and sets the ID to that. Let me know if you want sample code
ADatStac 1 year ago