adding data from sql to array

[sarahAria]

hi guys

I want to add usernames from mysq; database to an array like this

$existing_users=array('roshan','mike','jason');

mysql table looks like this

CREATE TABLE `Secure` (`id` int(11) NOT NULL auto_increment,`name` varchar(50) NOT NULL default '',`password` varchar(50) NOT NULL default '',`cookie_pass` varchar(50) NOT NULL default '',`state` char(1) NOT NULL default '0',`mail` varchar(100) NOT NULL default '',`active` char(1) NOT NULL default '0',`actcode` varchar(15) NOT NULL default '',`lastactive` datetime NOT NULL default '0000-00-00 00:00:00',PRIMARY KEY  (`id`)) TYPE=MyISAM AUTO_INCREMENT=1;

could yu plz help?

my problem is I don't know about arrays

[DarkWater]

If you don't mind me asking, why'd you post this in the regex board? >_<

 

Anyway, just put them into an array when you do your query.  Can I see your current query code?

[sarahAria]

I just don't know how to insert into array

it's a username availability check (ajax)