Hello, verybody,
currently i got one question.
i create a table in mysql database to store questions
which have following column fields: questionnumber,
questionbody, answers and etc.
My problem is if i delete one row(question) how can i
update the questionnumber in the easiest way which
means
questionnumber field is being used for sorting purposes then I would
suggest some sort of script (PHP, PERL or ASP) to control the value.
-Kevin
- Original Message -
From: bin cai [EMAIL PROTECTED]
To: mysql list [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 1:35 PM
Subject: auto update number