mysql_query variable.

[Dragonkai]

Is it possible to have this and work?


mysql_query($query)
or die(mysql_error());


mysql_query($secondquery)
or die(mysql_error());


$query = "UPDATE " . "test" . " SET " . $columntype[$j] . " = '" .
"1" . "' WHERE id =
'" . $i . "'";

$secondquery = "UPDATE " . "test" . " SET " . $columntype[$j] . " = '" .
"0" . "' WHERE id =
'" . $i . "'";

Thanks in advance, it's just I haven't seen it written like this anywhere.

[stephan.gerlach]

This wouldn't work because you run the query befor you have said what the query is. But this should work.






$query = "UPDATE " . "test" . " SET " . $columntype[$j] . " = '" .
"1" . "' WHERE id =
'" . $i . "'";

$secondquery = "UPDATE " . "test" . " SET " . $columntype[$j] . " = '" .
"0" . "' WHERE id =
'" . $i . "'";


mysql_query($query)
or die(mysql_error());


mysql_query($secondquery)
or die(mysql_error());

[Dragonkai]

Thanks!