Help with mysql duplicate row

[Izu Great]

i have table in my database, which has theses fields id, regno, courseid, level, session, the regno can be inserted more than once as well as level and session, also courseid but with previous regno. i need to prevent duplicate rows with regno, courseid, level, session, on a row.

[Kornfeld Eliyahu Peter]

And how is it related to web development? Anyway - try distinct...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

[Izu Great]

Thanks. I'm using it on php

[ZurdoDev]

You have a couple of options. 1. Add a unique index so MySql will not allow it. 2. When you are inserting records first check to see if it exists already.

There are only 10 types of people in the world, those who understand binary and those who don't.

[stevic]

You need to have Unique index in your table or Check before inserting anyway have you set an Increment ID ?

Freelance makes perfect | http://codetrash.com