Return to Answer

edited body

Source Link

edited Mar 25, 2015 at 21:04

Drupal 7 doesn't use the '%' place holders. Try this:

$primary_key = db_query("SELECT 'COLUMN_NAME'`COLUMN_NAME` FROM 'information_schema'`information_schema`.'COLUMNS'`COLUMNS` WHERE ('TABLE_SCHEMA'`TABLE_SCHEMA` = 'mydatabase') AND ('TABLE_NAME'`TABLE_NAME` = :tbl_name) AND ('COLUMN_KEY'`COLUMN_KEY` = 'PRI')", array(':tbl_name' => $mytable));

Drupal 7 doesn't use the '%' place holders. Try this:

$primary_key = db_query("SELECT 'COLUMN_NAME' FROM 'information_schema'.'COLUMNS' WHERE ('TABLE_SCHEMA' = 'mydatabase') AND ('TABLE_NAME' = :tbl_name) AND ('COLUMN_KEY' = 'PRI')", array(':tbl_name' => $mytable));

Drupal 7 doesn't use the '%' place holders. Try this:

$primary_key = db_query("SELECT `COLUMN_NAME` FROM `information_schema`.`COLUMNS` WHERE (`TABLE_SCHEMA` = 'mydatabase') AND (`TABLE_NAME` = :tbl_name) AND (`COLUMN_KEY` = 'PRI')", array(':tbl_name' => $mytable));

Source Link

created Mar 24, 2015 at 21:23

dwcdev

Drupal 7 doesn't use the '%' place holders. Try this:

$primary_key = db_query("SELECT 'COLUMN_NAME' FROM 'information_schema'.'COLUMNS' WHERE ('TABLE_SCHEMA' = 'mydatabase') AND ('TABLE_NAME' = :tbl_name) AND ('COLUMN_KEY' = 'PRI')", array(':tbl_name' => $mytable));