Mysql Error

[Hamlets666]

[code]$sql2 = "SELECT COUNT(*) FROM load WHERE `fname` = '$gfa' ";
$result2 = mysql_query($sql2) or die(mysql_error());
$num2 = mysql_result($result2, 0);[/code]

Error :
[b]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 'load WHERE `fname` = 'Muzyka/MP3/Zarubezhnye/N/Nightwish/Nightwish_-_Wish_I_Had_' at line 1[/b]

$gfa is /Muzyka/MP3/Zarubezhnye/N/Nightwish/Nightwish_-_Wish_I_Had_an_Angel.mp3

What`s wrong ? I do not get a point...  :-\

[Orio]

The underscore charater has a special meaning in SQL. Try escaping it:

[code]<?php

$gfa = str_replace("_", "\_", $gfa);
$sql2 = "SELECT COUNT(*) FROM load WHERE `fname` = '$gfa' ";
$result2 = mysql_query($sql2) or die(mysql_error());
$num2 = mysql_result($result2, 0);

?>[/code]

Orio.

[Hamlets666]

Now $gfa is Muzyka/MP3/Zarubezhnye/N/Nightwish/Nightwish\_-\_Wish\_I\_Had\_an\_Angel.mp3

But still the same :
[b]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 'load WHERE `fname` = 'Muzyka/MP3/Zarubezhnye/N/Nightwish/Nightwish\_-\_Wish\_I\_' at line 1[/b]

[Hamlets666]

also tried str_replace("_", "666", $gfa);
gfa - Muzyka/MP3/Zarubezhnye/N/Nightwish/Nightwish666-666Wish666I666Had666an666Angel.mp3
error:
[b]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 'load WHERE `fname` = 'Muzyka/MP3/Zarubezhnye/N/Nightwish/Nightwish666-666Wish666' at line 1[/b]

So "_" isn`t reason of error

[wildteen88]

add backticks (`) to load as well, eg [tt]`load`[/tt]. I think load is a mysql reserved keyword and MySQL is getting confused. There is nothing wrong with the string in $gfa. It something in the query that is kicking up a fuss.

[Hamlets666]

wildteen88, It`s alive  ;) Thanks...