drupal - PDOException: SQLSTATE[42000]: Syntax error or access violation Mysql -

i getting following error message when executing query:

pdoexception: sqlstate[42000]: syntax error or access violation: 1064 have error in sql syntax near '://www.website.com.br/manual_01/realm/1980-1988/r7678.htm' na linha 1: select (field_data_field_url.entity_id) field_data_field_url field_data_field_url.field_url_value = http//www.website.com.br/manual_01/realm/1980-1988/r7678.htm ; array ( ) em _xmlrpc_troca() 

this function drupal module:

$query = db_query("select (field_data_field_url.entity_id) field_data_field_url field_data_field_url.field_url_value = $url ");  foreach ($query $record) {  echo $record->entity_id;  }  return $record; 

if wrap '$url' ' ' works:

$query = db_query("select (field_data_field_url.entity_id) field_data_field_url field_data_field_url.field_url_value = '$url' "); 

but error @ xmlrpc response because sends '' , error while parsing response. response comes right data it´s useless because can´t parse it. knows how fix it?

edit:

the response comes this:

body: '30254<?xml version="1.0"?>\n\n<methodresponse>\n  <params>\n  <param>\n    <value><struct>\n  <member><name>entity_id</name><value><string>30254</string></value></member>\n</struct></value>\n  </param>\n  </params>\n</methodresponse>\n\n' 

this '30254 , ' @ end problems. got error message:

expaterror: not well-formed (invalid token): line 1, column 5 

you should try using db_query arguments.

<?php $query = db_query('select (field_data_field_url.entity_id) field_data_field_url field_data_field_url.field_url_value = :url', array(':url' => $url)); ?> 

you can alsow try using db_select() function.

<?php  $select = db_select('field_data_field_url', 'fdfu'); // fdfu alias $select->fields('fdfu', array('entity_id')); $select->condition('field_url_value', $url); $query = $select->execute();  foreach($query $result) {    echo $record->entity_id;  } ?>