It works when executing that sql. On Mar 7, 3:23 am, Jeremy Burns | Class Outfit <[email protected]> wrote: > You're not using Cake here. You are referring to $_POST and then running > plain SQL queries. > > What happens when you run the SQL in a db client? > > Jeremy Burns > Class Outfit > > [email protected]http://www.classoutfit.com > > On 7 Mar 2011, at 11:03, cake-learner wrote: > > > Still continue having problem with cakephp model. > > > I always have the account empty and don't know why. > > > Configure::write( "debug", 2 ); > > $emailAddress = $_POST[ 'email_address' ]; > > $sql = "SELECT * FROM accounts WHERE username = '" . $emailAddress . > > "' LIMIT 1"; > > echo $sql; > > $account = $this -> Account -> Query( $sql ); > > var_dump( $account ); > > > The following is the sql executed and works ( can get the result ) > > when try to execute this sql sentence on phpmyadmin. > > SELECT * FROM accounts WHERE username = '[email protected]' LIMIT 1 > > > -- > > Our newest site for the community: CakePHP Video > > Tutorialshttp://tv.cakephp.org > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > > [email protected] For more options, visit this group > > athttp://groups.google.com/group/cake-php
-- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
