I try to execute this very simple code:

 ....
$sql = 'SELECT field_regions_infrontpage_value FROM content_field_regions_infrontpage LIMIT 3';
$result_n = mysql_query($sql);

.....

and mysql_query yield 'false'.

1) I executed this query in a simple php script outside Drupal and I find no problem.
2) when I replace the query above with another query (with table-name with smaller string) inside Drupal there is no problem. After an extensive troubleshooting I found that the problem is that mysql_query() does not accept so long strings as table-name when the script is executed inside Drupal.

I must mention that the query is so simple because of the exhaustive troubleshooting (I was stripping my query) until I find why query is not executed.

Comments

damien tournoud’s picture

damien tournoud commented
Assigned: bill1821 » Unassigned
Status: Active » Postponed (maintainer needs more info)

Hum... What?

There are no reason why Drupal could interfere here. The problem is probably elsewhere.

Note that Drupal has an abstraction of mysql_query (in the form of db_query). But there is no reason the result could be different.

bill1821’s picture

bill1821 commented

Of course I know about (db_query).
I cannot imagine why there is a difference when someone execute mysql_query() via Drupal in respect with an other php-script. In fact that is the most peculiar problem I have ever met in php.

bill1821’s picture

bill1821 commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Maybe has to do with the size of the Drupal scripts.

gpk’s picture

gpk commented

Hmmmm I can see why you might be confused!

With a very simple query like that, if it is run via db_query() (see http://api.drupal.org/api/file/includes/database.mysql-common.inc/6/source) then your exact query should be passed on unchanged to _db_query() (see http://api.drupal.org/api/file/includes/database.mysql.inc/6/source) unchanged. The only material difference I can see there is that mysql is invoked via $result = mysql_query($query, $active_db); where (global) $active_db is the MySQL connection. I can't see how this would account for the behaviour you experience though! (http://uk3.php.net/manual/en/function.mysql-query.php) The only other thing I can think is that there is a subtle typo in your query text, though I'm sure you've checked it 1,000 times ...

damien tournoud’s picture

damien tournoud commented

Another thing: are you using mysql and mysqli consistently? (ie. if you try mysql_query, are you also using mysql on Drupal?)