sql syntax error
ik heb nu een stukje db update en moet dat daarna gewoon weergeven..
nu krijg ik alleen deze error:
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 'SET hint = '1' WHERE id='1'' at line 1
en het lukt me maar niet om het op te lossen..
dit is de code:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
<?php
*********************
***NIET VAN BELANG***
*********************
$sql = "UPDATE $db SET hint = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
$sql = "SELECT hint FROM $db WHERE id='".$_SESSION['user_id']."'";
$result = "mysql_query($sql) or die (mysql_error())";
$row = mysql_fetch_assoc($result);
echo $row['hint'];
?>
*********************
***NIET VAN BELANG***
*********************
$sql = "UPDATE $db SET hint = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
$sql = "SELECT hint FROM $db WHERE id='".$_SESSION['user_id']."'";
$result = "mysql_query($sql) or die (mysql_error())";
$row = mysql_fetch_assoc($result);
echo $row['hint'];
?>
Probeer dit eens:
Code (php)
1
2
3
4
5
2
3
4
5
<?php
$sql = "UPDATE ".$db." SET hint = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
?>
$sql = "UPDATE ".$db." SET hint = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
?>
Laat anders eens je $sql op het scherm zien met een echo... Dan kan je je query controleren.
Elwin
mag ik die fouten dan ook nog weten wat ze zijn??
want k weet het die variablen bij mij stinken altijd naar poep en k weet nooit precies wneer nou .$. '$' "$"
dus zeg aub even
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?
$sql = "UPDATE ".$db." SET hint = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
$sql2 = "SELECT hint FROM ".$db." WHERE id='".$_SESSION['user_id']."' LIMIT 1";
$result = mysql_query($sql2) or die (mysql_error());
$row = mysql_fetch_assoc($result);
echo $row['hint'];
?>
$sql = "UPDATE ".$db." SET hint = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
$sql2 = "SELECT hint FROM ".$db." WHERE id='".$_SESSION['user_id']."' LIMIT 1";
$result = mysql_query($sql2) or die (mysql_error());
$row = mysql_fetch_assoc($result);
echo $row['hint'];
?>
@ Wes, ik kom niet aan 13 hoor :\
Gewijzigd op 01/01/1970 01:00:00 door Thijs X
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 'WHERE id='1'' at line 1
en k heb dan dit script:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
<?php
include_once("config.php");
include_once("lang/lang_".$lang.".php");
require("safe.php");
$sql = $sql = "UPDATE `hetvaagspel` SET `hint` = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
$sql2 = "SELECT hint FROM ".$db." WHERE id='".$_SESSION['user_id']."'";
$result = mysql_query($sql2) or die (mysql_error());
$row = mysql_fetch_assoc($result);
echo $row['hint'];
?>
include_once("config.php");
include_once("lang/lang_".$lang.".php");
require("safe.php");
$sql = $sql = "UPDATE `hetvaagspel` SET `hint` = '1' WHERE id='".$_SESSION['user_id']."'";
mysql_query($sql) or die (mysql_error());
$sql2 = "SELECT hint FROM ".$db." WHERE id='".$_SESSION['user_id']."'";
$result = mysql_query($sql2) or die (mysql_error());
$row = mysql_fetch_assoc($result);
echo $row['hint'];
?>
ik weet dat het slecht is om fouten te verbergen dus probeer ik het op te lossen :P