[SOLVED] SELECT Query fails (Searching for Strings with Backslashes)

[ZwoksKorbi]

Hello,

 

at the moment i'm developing a tool to monitor the diskusage.

I've got a Table with the path's and one with the effectives.

(See Attachment)

 

The following Query fails with the error:

Column 'path' cannot be null

 

INSERT INTO 
  `effectives` (`size`,`files`,`path`)
VALUES 
  (0.00,
  0,
  (SELECT `ID` FROM `directories` WHERE `path` LIKE "\\\\BIN-SV-N2V\\CIFS_VOL0$\\hochbau\\00_CAD"))

The data i want to find can be seen in Attachment 2 (directories-Table).

 

The error is thrown by the Subquery.

 

What am I doing wrong?

Please help me.

 

 

 

[attachment deleted by admin]

[vikramjeet.singla]

use mysql_escape_string to escape slashes or any special characters in your search string

[ZwoksKorbi]

Hi,

 

i've used it:

$sql = "INSERT INTO 
  `effectives` (`size`,`files`,`path`)
VALUES 
  (".$data[1].",
   ".$data[2].",
   (SELECT `ID` FROM `directories` WHERE `path` LIKE \"".$db->real_escape_string(trim($data[3]))."\"))";

[fenway]

Echo $sql... and what about magic quotes?

[ZwoksKorbi]

Hello,

i've solved the problem.

The values of LIKE needs to be double-escaped.