alexszilagyi Posted July 6, 2009 Share Posted July 6, 2009 Hi there, Can anyone help me converting this query: SET @statefieldid=(SELECT fieldid FROM `#__comprofiler_fields` WHERE `name`='cb_state'); :| locally it works because I have MySQL 5th version but on my web server doesn't because they have 4th version and they don't wan't to upgrade soon.... Please help & Thank you very much! Quote Link to comment https://forums.phpfreaks.com/topic/164996-solved-mysql-5-query-to-mysql-4/ Share on other sites More sharing options...
alexszilagyi Posted July 6, 2009 Author Share Posted July 6, 2009 I've got it, Thank you fenway! Check this link: http://www.phpfreaks.com/forums/index.php/topic,254004.0.html Quote Link to comment https://forums.phpfreaks.com/topic/164996-solved-mysql-5-query-to-mysql-4/#findComment-870022 Share on other sites More sharing options...
fenway Posted July 10, 2009 Share Posted July 10, 2009 No problem... but don't double-post next time. Quote Link to comment https://forums.phpfreaks.com/topic/164996-solved-mysql-5-query-to-mysql-4/#findComment-872501 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.