[Mark_Weston]

INSERT to insert a record
UPDATE to update a record


To do what you want use the UPDATE function.

For example
This is a textboxl:
-------------------------------------------
| Set Badge |
| #9582 |

Button:
-----------
| Submit |
-----------

When you use the UPDATE function it will update the X record.

So lets you're an admin you logged in you want to set an officers b adge number.

You go to lets say..

Admin CP >> Set Badge.

"Enter Officers Name"

"Mark_Weston" and lets say my account is user id 857

setbadge.php?userid=857

This shows up:

-------------------------------------------
| Set Badge |
| # |

Button:
-----------
| Submit |
-----------

You enter a badge number press submit

and the UPDATE record will insert the new badge number into the SQL.


Its kind of hard to explain, but is that what you want to do?


That's how I made my web based MDC.