hello programmers am having an update issue and i dont know how to go about it am gonna try n explain it the way i can plz bear with me.
i have a table called bids and two important column called bidder and tagged

when (bidder 5) has no one to tag he simple drops a bid and when another bidder comes along(bidder 3) he tags (bidder 5) i want bidder 5 row to update showing (bidder 3)in his row.

for example
bidder 5 place bid it looks like this
column

bidder ...........tagged
5.................... 0
no one to tag so it shows zero

so if bidder 5 finally get tagged by someone (bidder 3) it update showing the person that tag bidder 5 and it will look like this

column
roll for bidder 5 will look like this

bidder...............tagged
5 .......................3

complete row with bidder5 and bidder 3

bidder...............tagged
5 .......................3
3.......................5

hope u understand

Check your database table design structure.


This is how i will rather implement it.

I will have 2 tables.

- Bidder ===== To store details of every eligible bidder in my system

- BidderTags ==== To store all biddings and Tags.


Now each of the table will have the following fields :

== > BidderTable
BidderId - A unique Id of bidders {Primary Keys}
BidderName -- Full Name of the bidder
....... All other bidder related fields/data


==> BidderTagTable
BidderTagId ===AutoNumber that can act as Primary Key
BidderId === The Unique of the bidder in the system. a Foriegn Key to the BidderId in the Bidder Table.
BidderTagged === The Id of the bidder that was tagged
Active === A boolean value that indicates if this record is still ok or not
......... Other information related to the BidderTag (Dates, amount etc )

So when a bidder tags another bidder, you just drop a record in your BidderTag Table.

To know the number of tags a bidder have, run : "SELECT count(*) FROM BidderTagTable WHERE BidderTagged = 00005 AND Active = true"


You can even join the table to know the names of those who tagged him. You dont have to keep updating any row so you can keep logs for audit purpose.


Try read up on Database Normalization and understand the concept, you will not be having this kind of problem.


I hope this helps.

AntiWailer:
Check your database table design structure.


This is how i will rather implement it.

I will have 2 tables.

- Bidder ===== To store details of every eligible bidder in my system

- BidderTags ==== To store all biddings and Tags.


Now each of the table will have the following fields :

== > BidderTable
BidderId - A unique Id of bidders {Primary Keys}
BidderName -- Full Name of the bidder
....... All other bidder related fields/data


==> BidderTagTable
BidderTagId ===AutoNumber that can act as Primary Key
BidderId === The Unique of the bidder in the system. a Foriegn Key to the BidderId in the Bidder Table.
BidderTagged === The Id of the bidder that was tagged
Active === A boolean value that indicates if this record is still ok or not
......... Other information related to the BidderTag (Dates, amount etc )

So when a bidder tags another bidder, you just drop a record in your BidderTag Table.

To know the number of tags a bidder have, run : "SELECT count(*) FROM BidderTagTable WHERE BidderTagged = 00005 AND Active = true"


You can even join the table to know the names of those who tagged him. You dont have to keep updating any row so you can keep logs for audit purpose.


Try read up on Database Normalization and understand the concept, you will not be having this kind of problem.


I hope this helps.

can't i work on one table with this? dont really get what u said.

skyhighweb:
can't i work on one table with this? dont really get what u said.

You will have problems like the one are facing with 1 table.

Read normalization.

U need minimum of 2 tables for what u are doing.


Can you tell me what you dnt get may be I can explain further ?

can u pm me thanks

All u need is to search for  Database Normalization and understand the concept, as a matter of facts, u need to learn best practice as this will point u to the right direction.