help me to autodecrement a field in a table when delete any entry from table
example:
!--------------------------
!id name userno
!--------------------------
! 1 harry 101
!--------------------------
! 2 abc 102
!--------------------------
! 3 xyz 103
!--------------------------
! 4 xyz 104
!-------------------------
if we delete 3rd entry from table than 104 will automaticaly decrement in 103 how is this possible pls help me
dev.vini
0
Newbie Poster
Recommended Answers
Jump to PostFirst make a DELETE query. It it succeeds, then make an UPDATE query - ex:
$id=3; mysql_connect("localhost","username","password") or die(mysql_error()); mysql_select_db("dbname") or die(mysql_error()); mysql_query("DELETE FROM tableName WHERE `id`=$id") or die(mysql_error()); mysql_query("UPDATE tableName SET `userno`=`userno`-1 WHERE `id` > $id") or die(mysql_error());
Jump to PostAlready answered: http://www.daniweb.com/forums/thread310054.html
All 7 Replies
hielo
65
Veteran Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
dev.vini
0
Newbie Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
dev.vini
0
Newbie Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.