[RESOLVED] Whats wrong with this query?

sapoxgn

It works on my linux server.. but when i upload to a windows server i get this error:

You have an error in your SQL syntax near ' respostas SET respostas.salva=1 WHERE respostas.enquete=enquete.enquete_id AND ' at line 1

Here the query:

mysql_query("UPDATE respostas, enquete SET respostas.salva=1 WHERE respostas.enquete=enquete.enquete_id AND enquete.modulo=$modulo AND respostas.usuario=$usuario");

Please i need to put it to work 🙁

mrhappiness

maybe the version of mysql running at your windows server doesn't support this type of update, it's version 4.0.4 at least iirc

sapoxgn

mrhappiness wrote:
maybe the version of mysql running at your windows server doesn't support this type of update, it's version 4.0.4 at least iirc

hum.. here the info about the server:

http://www.nhp.com.br/planejamento/admin/imgs/index.php

i l try to make a work around about it :glare:

sapoxgn

i ve made a work around.. but.. i hate this kind of dirt code... :glare:

$query = mysql_query("SELECT respostas.resposta_id FROM respostas, enquete WHERE respostas.enquete=enquete.enquete_id AND enquete.modulo=$modulo AND respostas.usuario=$usuario");
	while($resposta = mysql_fetch_assoc($query)) {
		$resposta_id = $resposta['resposta_id'];
		if(mysql_query("UPDATE respostas SET salva=1 WHERE resposta_id=$resposta_id") or die(mysql_error())) {
// feedback..