[RESOLVED] Insert Ignore-two columns

leagal4ever

Mysql have UNIQUE Name and Tag it shouldn't insert data if aney of those two is same, now it work when both are same.

				$sql = "INSERT IGNORE INTO tribe (Name, Tag, Points, PointsTotal, Villages, Rank) VALUES ('$addName', '$addTag', 11, 11, 1, 3)";
				$result = mysql_query($sql);/*  IF NOT EXISTS, INSERT IGNORE */

				if (!mysql_affected_rows()) {
					notice ("Tribe name or tag is duplicated. Change it.", 1);
				}

Weedpacket

¿Que?

You're saying that you have a table - which has UNIQUE constraints on both the Name and Tag columns - has two rows with either the same Name or the same Tag?

Why not just skip the IGNORE and then see if the INSERT statement succeeds or not?

leagal4ever

Yes all, i rather show pic from phpmyadmin so i didnt do something wrong , skip IGNORE and its same.

bradgrafelman

What is your goal here? If I signup with name "Brad" and tag "PHP", are you wanting both of those to be separate unique values? E.g. no one else can signup with the name "Brad" and any tag, or with any name and have "PHP" as a tag?

Or instead are you trying to make sure that no one signs up again with both "Brad" as a name and "PHP" tag (but "Weedpacket" as name and "PHP" as tag would be allowed)?

leagal4ever

bradgrafelman you make me think here how is phpmyadmin or db know what exactly i mean of course it must have option for both. So i change in phpmyadmin those unique and ungroup them and it work. No duplicates not for name or tag. Thanks for help learn something new 🙂