Hey there. Ive got a problem with PHP/Mysql. I hope somebody could help me out.
I dont know pretty well MySQL, but I built a Query and tested in phpmyadmin and it worked fine.
But when I try to ejecute the query by PHP (mysql_query() function) it seems to be wrong and gets me the 1064 error.
Don´t know whats happening. Can somebody help me please?
This is the Query :
SET @village = 1;
SET @segundos = (SELECT (( TO_DAYS( NOW() ) - 73000 ) * 86400 + TIME_TO_SEC( NOW() )) - (( TO_DAYS( `lastcheck` ) - 73000 ) * 86400 + TIME_TO_SEC( `lastcheck` )) FROM village WHERE `id` = @village);
SET @addwood = (SELECT (`addwood` * @segundos) FROM village WHERE `id` = @village);
SET @addstone= (SELECT (`addstone` * @segundos) FROM village WHERE `id` = @village);
SET @addiron = (SELECT (`addiron` * @segundos) FROM village WHERE `id` = @village);
SET @addgold= (SELECT (`addgold` * @segundos) FROM village WHERE `id` = @village);
UPDATE `village` SET wood = wood+@addwood,stone = stone+@addstone,iron = iron+@addiron,gold= gold+@addgold,lastcheck = NOW() WHERE `id` = @village;
SELECT @addwood as addwood, @addstone as addstone,@addiron as addiron,@addgold as addgold
Check it at www.magollo.com.ar/test.php
