How do I add an index when adding a new field?

[jeddi]

Hi,

I would like to add an index as well as the new field.

I tried this, but it failed:

PHP Code:

$sql = "ALTER TABLE `clients` ADD `new` char(1) NOT NULL default 'y',
 KEY `new` (`new`)";

 $result = mysql_query($sql)
    or die("could not ALTER clients.". mysql_error()); 


Can anyone please help me get it right?
Thanks

[djm0219]

ALTER TABLE `clients` ADD `new` char(1) NOT NULL default 'y' , ADD INDEX ( new)

[jeddi]

Thanks for help