php select ExtractValue

php select ExtractValue

digg 1:04 AM
Hi
when execute this query
<?php
$sqlr ="select *
from biblioitems
where EXTRACTVALUE( marcxml, \ '//datafield[@tag="520"]/subfield[@code="d"]')='' ";

give me this 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 '\ "//datafield[@tag="520"]/subfield[@code="d"]")=""' at line 4

any help??

from PHP http://ift.tt/1Ss0V8a
via IFTTT
Next
« Prev Post
Previous
Next Post »
Thanks for your comment
Subscribe to: Post Comments (Atom)