Hello,
I am getting a sql syntax error when I try the execute function. I
errors when I try to use what I think to be the right syntax any other
kind of experimental syntax ;) Anyway, this is what I have:
$this->User->execute("UPDATE users WHERE username = $username SET
friends_list = concat(friends_list, $friendName)");
I have also tried this:
$this->User->execute("UPDATE 'users' WHERE 'username' = $username SET
'friends_list' = concat(friends_list, $friendName)");
Here is the error:
Query: UPDATE users WHERE username = joe SET friends_list =
concat(friends_list, Albert2640)
Warning: SQL Error: 1064: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'WHERE username = joe SET friends_list =
concat(friends_list, Albert2640)' at line 1 in C:\xampp\htdocs\konimo
\cake\libs\model\datasources\dbo_source.php on line 440
Thanks for any help
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
