On 10/4/2011 2:39 PM, Paul McNett wrote: > On 10/4/11 11:00 AM, Jarvis, Matthew wrote: >> Maybe as a continued public service you could leave it open and let Jeff >> play with it? > > host: paulmcnett.com > user: brewdomain > pass: domainbrew > db: brewdomain > > Someone else can post the DSN - been too long for me to remember how to > format those!
Paul, Can you add this table (below)? I'll put together a demo of how my framework accesses a MySQL database over the web and this table is good for a basic example. create table `brewdomain`.`users`( `iid` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `cname` varchar(16) NOT NULL COMMENT 'User\'s name', `cuserid` varchar(16) NOT NULL COMMENT 'User\'s signon ID', `cpassword` varchar(16) NOT NULL COMMENT 'User\'s password', `iactive` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Active? (1=yes, 0=no)', PRIMARY KEY (`iid`)) Engine=MyISAM checksum=1 comment='mjb 10-04-11 created for demo purposes' delay_key_write=1 row_format=dynamic For the record, it would be better to store the hash# instead of the actual password, so don't waste bytes chastising me on this example. :-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
