Not allowing duplicate values to an array - Site Owners Forums

mjvndhsb · 09-21-2011, 08:44 PM

Hi,
How can I prevent duplicate values from getting stored into an array? I am trying to dynamically populate an array with data using the concat() function, but I do not want to allow duplicate selection to be stored in the array. Total noob here. Pls help! Thanks.

Spoint_Vinil · 02-29-2012, 01:56 AM

you need to sort the array and then check for duplicates.hope this would work or let me know if not working still

jaydeee · 11-10-2012, 11:13 PM

that would be easy if you have ID on every record. So load this on your array:
select distinct(id) from table1
hope that helps.

09-21-2011, 08:44 PM	#1
mjvndhsb Registered User Join Date: Jul 2011 Posts: 177	Not allowing duplicate values to an array Hi, How can I prevent duplicate values from getting stored into an array? I am trying to dynamically populate an array with data using the concat() function, but I do not want to allow duplicate selection to be stored in the array. Total noob here. Pls help! Thanks. __________________ *To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.* *To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.*

02-29-2012, 01:56 AM	#2
Spoint_Vinil Moderator Join Date: Sep 2011 Location: INDIA Posts: 234	you need to sort the array and then check for duplicates.hope this would work or let me know if not working still __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

11-10-2012, 11:13 PM	#3
jaydeee Registered User Join Date: Mar 2010 Posts: 40	that would be easy if you have ID on every record. So load this on your array: select distinct(id) from table1 hope that helps. __________________ Get your To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)