foutje in de update query misschien?
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
$update_signup = mysql_query("UPDATE `quest_info` SET `published` = '1', `ended` = '0' `$publish_date` = '$datum' WHERE `quest_id` = '$quest_id'") or die(mysql_error());
[/code
[size=xsmall][i]Toevoeging op 20/02/2013 17:35:12:[/i][/size]
update:
de $ is weggehaald in de code. en de error die tevoorschijnt komt is:
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 '`publish_date` = '20, 2, 2013' WHERE `quest_id` = 'qu001'' at line 1
[/code
[size=xsmall][i]Toevoeging op 20/02/2013 17:35:12:[/i][/size]
update:
de $ is weggehaald in de code. en de error die tevoorschijnt komt is:
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 '`publish_date` = '20, 2, 2013' WHERE `quest_id` = 'qu001'' at line 1
Ja, dus daar of direct er vóór: Er mist een komma.