Page 1 of 1

very fast question (mysql query/php getting result)

Posted: Wed Oct 29, 2008 7:36 pm
by spamyboy

Code: Select all

$result = mysql_query("
                            SET @counter = 0;
                            SELECT `static_id`,
                            IF (`static_position`=@counter, @counter:=@counter+1, @counter:=@counter+1) as `static_new_position`
                            FROM `gcms_static` ORDER BY `static_new_position`, `static_id`") or die(mysql_error());

Code: Select all

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 '; SELECT `static_id`, IF (`static_position`=@counter, @counter:=' at line 1
Obviously I use some wrong method to make such query.

Re: very fast question (mysql query/php getting result)

Posted: Wed Oct 29, 2008 7:55 pm
by VladSun
You can't use multiple queries in mysql_query().
mysql_query() sends an unique query (multiple queries are not supported) ...

Re: very fast question (mysql query/php getting result)

Posted: Wed Oct 29, 2008 8:08 pm
by spamyboy
VladSun wrote:You can't use multiple queries in mysql_query().
mysql_query() sends an unique query (multiple queries are not supported) ...
Thank you.