10-18-2008, 03:05 PM
|
#31 (permalink)
|
|
The Prestige
Join Date: Oct 2007
Location: Manchester, UK
Posts: 854
Thanks: 32
|
Quote:
|
Only if the link column has a unique index on it.
|
Yea sorry I had forgotten that.
Anyway you can quickly add a unique to a column with a simple SQL statement:
sql Code:
ALTER TABLE `upload` ADD UNIQUE (`link`)
Your script works now?
__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)
|
|
|
|