Unique Field

fixmycom

I am installing a portal (php-nuke), that has a url unique field in addlink, ie no two url entries can be the same ... it also will not accept a null field (well it will but once only) ... i need to be able to create listings with addlink for subscribers who do not have a url ... so i need the url field to accept null entries ... is this as simple as changing the url field in phpmyadmin so that the url field is no longer unique?

Atli

Hi. Welcome to Bytes!

A unique field should be able to accept multiple null values, given that it was not created with the
"Not Null" option.

fixmycom

Quote:

Originally Posted by Atli

Hi. Welcome to Bytes!

A unique field should be able to accept multiple null values, given that it was not created with the
"Not Null" option.

Thanx ... bearing in mind it has been created with the not null option ... can i just go in to phpmyadmin and change it?

Atli

I'm not sure on the specifics of phpMyAdmin, but you could change the field with an Alter Table query. Like, for example:

Expand|Select|Wrap|Line Numbers

 
ALTER TABLE myTable

CHANGE theField theField VarChar(100) unique;

Unique Field

re: Unique Field

re: Unique Field

re: Unique Field

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about