On Tuesday, April 17, 2001, at 12:41 PM, Mark Maggelet wrote:
> That would be true if I left out the 'ignore'. The way it is here it
> will automatically toss the duplicates.
Whoops, missed that. I stand corrected.
Colin
-
Colin
On Tue, 17 Apr 2001 12:34:27 -0700, Colin Putney
([EMAIL PROTECTED]) wrote:
>On Tuesday, April 17, 2001, at 12:19 PM, Mark Maggelet wrote:
>
>> That works for mysql. He probably just wants to kill the
>>duplicates,
>> so there's an easier way: add a unique index to the phone_number
>> field.
>>
>
On Tuesday, April 17, 2001, at 12:19 PM, Mark Maggelet wrote:
> That works for mysql. He probably just wants to kill the duplicates,
> so there's an easier way: add a unique index to the phone_number
> field.
>
> alter ignore table $table add unique (phone_number);
Yep, that will prevent dupli
On Tue, 17 Apr 2001 11:30:07 -0700, Colin Putney
([EMAIL PROTECTED]) wrote:
>On Tuesday, April 17, 2001, at 11:00 AM, Devin Atencio wrote:
>
>> I have a SQL Table that has over 1,000 records and I was wanting
>> to write a script that would find duplicate phone numbers and
>> then list the duplic
Hm...it's not fast, but it should work.
Do a select statement to take out just the phone numbers, then do something
like:
while ($row = mysql_fetch_row($result))
{
$array[] = $row[0];
}
$amount = array_count_values($array);
$imax = sizeof($amount);
for ($i = 0; $i < $imax; $i++)
{
if (
On Tuesday, April 17, 2001, at 11:00 AM, Devin Atencio wrote:
> I have a SQL Table that has over 1,000 records and I was wanting
> to write a script that would find duplicate phone numbers and
> then list the duplicate phone numbers. I have been trying to
> think on how to do this but I can't t
I have a SQL Table that has over 1,000 records and I was wanting
to write a script that would find duplicate phone numbers and
then list the duplicate phone numbers. I have been trying to
think on how to do this but I can't think of a way. Can someone
please help me on some code I could write to
7 matches
Mail list logo