ident_current scope_identity and @@identity need help
Posted: Thu Jan 13, 2011 2:04 pm
I tried to use the each of the three functions mentioned in the subject line in the following query and kept getting error messages.
Here are the error messages I got for each of the 3 respective functions:
What could possible be going wrong? Seems to me like the functions are deprecated. Any help is appreciated.
Code: Select all
$query = "INSERT INTO blogs (blog_id, member_id, title, entry, blog_date) VALUES (0, @@IDENTITY('members'), '{$_POST['title']}', '{$_POST['entry']}', NOW())";
Here are the error messages I got for each of the 3 respective functions:
Code: Select all
Could not add the entry because: FUNCTION a7522929_dbs.IDENT_CURRENT does not exist. The query was INSERT INTO blogs (blog_id, member_id, title, entry, blog_date) VALUES (0, ident_current('members'), 'We have go so this is your house.', 'Mami Ngeh.', NOW()).
Could not add the entry because: FUNCTION a7522929_dbs.SCOPE_IDENTITY does not exist. The query was INSERT INTO blogs (blog_id, member_id, title, entry, blog_date) VALUES (0, ident_current('members'), 'We have go so this is your house.', 'Mami Ngeh.', NOW()).
Could not add the entry because: 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 '('members'), 'We have go so this is your house.', 'Mami Ngeh.', NOW())' at line 1. The query was INSERT INTO blogs (blog_id, member_id, title, entry, blog_date) VALUES (0, @@IDENTITY('members'), 'We have go so this is your house.', 'Mami Ngeh.', NOW()).