René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SQLSTATE[42000] OR SQLSTATE[42S22]","articleBody":"When i set \n\n```\n// Table's primary key\n$primaryKey = '`company`.`id`';\n```\n\nin ssp.class on this part\n\n```\n// Total data set length\n$count_request = \"SELECT COUNT(`{$primaryKey}`)\";\nif ($joinQuery) {\n    $count_request .= $joinQuery;\n} else {\n    $count_request .= \"FROM   `$table`\";\n}\n```\n\nI get this sql:\n\n```\nSELECT COUNT(``company`.`id``) FROM `company` LEFT JOIN `city` ON `company`.`city` = `city`.`id`\n```\n\nAnd error\n\n```\n{\"error\":\"An SQL error occurred: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'company`.`id``) FROM `company` LEFT JOIN `city` ON `company`.`city` = `city`.`id' at line 1\"}\n```\n\nAnd when i set\n\n```\n$primaryKey = 'company.id';\n```\n\nI get this sql:\n\n```\nSELECT COUNT(`company.id`) FROM `company` LEFT JOIN `city` ON `company`.`city` = `city`.`id`\n```\n\nAnd error\n\n```\n{\"error\":\"An SQL error occurred: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company.id' in 'field list'\"}\n```\n\nI think that need set \n\n```\n$count_request = \"SELECT COUNT({$primaryKey})\";\n```\n\nwithout \n\n```\n`\n```\n\nAnd use\n\n```\n$primaryKey = '`company`.`id`';\n```\n","author":{"url":"https://github.com/tagplus5","@type":"Person","name":"tagplus5"},"datePublished":"2015-12-19T22:57:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/7/ssp/issues/7"}