FOUT : You have an error in your SQL syntax; check the manual that corresponds t
Code (php)
1
FOUT : 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 ringtoneid=''' at line 1
Deze pagina maakt gebruik van het volgende script: (eerste stukje)
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<?php
include"inc_connect.php";
include"config.php";
// query samenstellen en uitvoeren
$query = "SELECT * FROM ". $tabel ." WHERE ringtoneid='". $id ."'";
$result = mysql_query($query) or die("FOUT : " . mysql_error());
// controleren of mail-adres is gevonden
if (mysql_num_rows($result) > 0){
// JA: variabelen toekennen
while(list($id, $ringtoneid, $artist, $song, $sectionid, $nokiaonly, $newdate) = mysql_fetch_row($result)){
[/code]
Iemand een idee wat hier fout is?
include"inc_connect.php";
include"config.php";
// query samenstellen en uitvoeren
$query = "SELECT * FROM ". $tabel ." WHERE ringtoneid='". $id ."'";
$result = mysql_query($query) or die("FOUT : " . mysql_error());
// controleren of mail-adres is gevonden
if (mysql_num_rows($result) > 0){
// JA: variabelen toekennen
while(list($id, $ringtoneid, $artist, $song, $sectionid, $nokiaonly, $newdate) = mysql_fetch_row($result)){
[/code]
Iemand een idee wat hier fout is?
Gewijzigd op 01/01/1970 01:00:00 door Peter S
Edit:
of $id. Echo je query eens naar het scherm?
Gewijzigd op 01/01/1970 01:00:00 door Jan Koehoorn
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?php
$sql = "
SELECT *
FROM ". $tabel ."
WHERE ringtoneid=". $id;
if (!$res = mysql_query ($sql)) {
echo '<pre>' . print (htmlentities (str_replace ("\t", '', $sql)), true) . '</pre>';
trigger_error (mysql_errno () . ': ' . mysql_error ());
}
?>
$sql = "
SELECT *
FROM ". $tabel ."
WHERE ringtoneid=". $id;
if (!$res = mysql_query ($sql)) {
echo '<pre>' . print (htmlentities (str_replace ("\t", '', $sql)), true) . '</pre>';
trigger_error (mysql_errno () . ': ' . mysql_error ());
}
?>
PHP Newbie schreef op 31.12.2007 12:22:
Ik gok dat $tabel ook leeg is. Als het enkel om $id zou gaan, zou MySQL een andere foutmelding geven.nee, het ringtone ID is leeg.
Parse error: syntax error, unexpected ',' in /home/pcfoutme/public_html/ring/test.php on line 7
pps. Beter:
Gewijzigd op 01/01/1970 01:00:00 door Joren de Wit
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
include"inc_connect.php";
include"config.php";
// query samenstellen en uitvoeren
// $query = "SELECT * FROM ". $table ." WHERE ringtoneid='". $id ."'";
$sql = "
SELECT *
FROM ". $tabel ."
WHERE ringtoneid=". $id;
if (!$res = mysql_query ($sql)) {
echo '<pre>' . htmlentities (str_replace ("\t", '', $sql)) . '</pre>';
trigger_error (mysql_errno () . ': ' . mysql_error ());
}
$result = mysql_query($query) or die("FOUT : " . mysql_error());
// controleren of mail-adres is gevonden
if (mysql_num_rows($result) > 0){
// JA: variabelen toekennen
while(list($id, $ringtoneid, $artist, $song, $sectionid, $nokiaonly, $newdate) = mysql_fetch_row($result)){
$nummer = $song;
$bestelnummer = $ringtoneid;
$artiest = $artist;
$categorie = $sectionid;
$nokia = $nokiaonly;
$datum = $newdate;
}
}
$titel ='';
if($artiest!==''){
$titel = "$artiest - ";
}
$titel .= "$nummer";
include"top.php";
?>
include"inc_connect.php";
include"config.php";
// query samenstellen en uitvoeren
// $query = "SELECT * FROM ". $table ." WHERE ringtoneid='". $id ."'";
$sql = "
SELECT *
FROM ". $tabel ."
WHERE ringtoneid=". $id;
if (!$res = mysql_query ($sql)) {
echo '<pre>' . htmlentities (str_replace ("\t", '', $sql)) . '</pre>';
trigger_error (mysql_errno () . ': ' . mysql_error ());
}
$result = mysql_query($query) or die("FOUT : " . mysql_error());
// controleren of mail-adres is gevonden
if (mysql_num_rows($result) > 0){
// JA: variabelen toekennen
while(list($id, $ringtoneid, $artist, $song, $sectionid, $nokiaonly, $newdate) = mysql_fetch_row($result)){
$nummer = $song;
$bestelnummer = $ringtoneid;
$artiest = $artist;
$categorie = $sectionid;
$nokia = $nokiaonly;
$datum = $newdate;
}
}
$titel ='';
if($artiest!==''){
$titel = "$artiest - ";
}
$titel .= "$nummer";
include"top.php";
?>
En ik krijg deze foutmelding:
Code (php)
1
2
3
4
5
6
2
3
4
5
6
SELECT *
FROM
WHERE ringtoneid=
Notice: 1064: 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 ringtoneid=' at line 3 in /home/pcfoutme/public_html/ring/order.php on line 15
FOUT : Query was empty
FROM
WHERE ringtoneid=
Notice: 1064: 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 ringtoneid=' at line 3 in /home/pcfoutme/public_html/ring/order.php on line 15
FOUT : Query was empty
Gewijzigd op 01/01/1970 01:00:00 door Peter S
Zet gewoon de juiste tabelnaam in de query, dat voorkomt een hoop problemen. Jouw huidige probleem verdwijnt dan ook als sneeuw voor de zon.