php select ExtractValue

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

Share :

Tweet

✚

Related Post

• WAMP: phpMyAdmin - Error Cannot start session without errors...When I try to connect to myPhpAdmin, I get this: phpMyAdmin - Error Cannot start session without e
• Cookies set by CakePHP don't show upI've been ignoring this problem for a while because the user impact was low but that's changing as
• Errors after upgrade PHP version from 5.3 to 5.5
• Paypal IPN Mass Payment sampleGuys, I need some help, anyone here have a sample of Paypal IPN using php for mass payment? or ca
• how do i properly combine Session Start and UTF-8 headerSomething i never seen before happened on my hosting server. a couple of PHP files containing CHIN
• Align in PhP?Hey, well on my arcade I'm looking to align the add code in the center, the thing is you set the ad