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 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

-- 
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

Reply via email to