[Resolved] Deleting Row while updating a Column

[nomad9]

Hi!

I've got a table that contain a list of question for a poll. My table look like this:

---ID---Question---Rank---

ID = autoincrement field
Group = indentify a kind of questions
Question = the question text
Rank = the question order in the poll

I have create a page to add question, modify their rank and delete them.

But if I have 10 questions in group A (with rank 1,2,3,4,...,10) and i have to delete the question#5 (with rank 5), is there an easy way to reset the group A rank so question#6 will be rank#5, and so on.

Is anybody have an idea to do this ?????

nomad

[pete_bisby]

If you always know the rank value of the question you wish to delete, you could run the following queries:

$qry = "DELETE FROM tblQuestion WHERE Group='$groupID' AND Rank=$rankID";
// ... then run ...
$qry = "UPDATE tblQuestion SET Rank=Rank-1 WHERE Group='$groupID' AND Rank>$rankID";

I wouldn't use "Group" as an attribute name, though - you may have problems further down the line, because databases usually regard this as a reserved word (e.g. GROUP BY statements within SQL).

[nomad9]

Yes I know for Group name ...

Thank for the help it's just what i need