Simple task to convert a php-mysql request
3 USDif (($fieldName == 'ordernum') && !empty($fieldData)) {
$sql = sprintf("SELECT GROUP_CONCAT(innum SEPARATOR ',') FROM order WHERE id IN (%s) ", $fieldData);
$customText = $this->GetConnection()->ExecScalarSQL($sql);
$handled = true
The
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order WHERE id IN (999)' at line 1
есть не большой запрос который не корректно работает нужно его передать что бы корректно отрабатывал
if (($fieldName == 'ordernum') && !empty($fieldData)) {
$sql = sprintf("SELECT GROUP_CONCAT(innum SEPARATOR ',') FROM order WHERE id IN (%s) ", $fieldData);
$customText = $this->GetConnection()->ExecScalarSQL($sql);
$handled = true;
}
вот отшибка Cannot execute SQL statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order WHERE id IN (999)' at line 1
Client's feedback on cooperation with Vanya Kutuzov
Simple task to convert a php-mysql requestI strongly recommend!
Freelancer's feedback on cooperation with Konstantin Kuyevda
Simple task to convert a php-mysql requestSuch a easy project, made literally in 5 minutes, indicated a mistake, the payment was received, all superb.
Current freelance projects in the category PHP
Website for a driving school WordPress with a management system.A website needs to be developed for a small driving school on WordPress with a learning and payment management system. More interested in the management system itself rather than the design, which we want in the admin panel of the site. A private cabinet is needed for students,… PHP, Web programming ∙ 6 proposals |
Synchronization CRM with ERP
1754 USD
|
Automating email forwarding for a domain (MX forward)There is a need to develop MX forwarding for the mail domain (all emails coming to the domain). It should be similar to: https://improvmx.com/ Currently, we are talking about the technical part of email forwarding, without billing. As far as I understand, there is a similar… PHP, Web programming |
Telegram receive sms php
315 USD
It is necessary to extract, for example, messages from a bot to a notepad on the website. The bot is not mine - third-party. The website is in PHP. PHP ∙ 2 proposals |
Gmail get message php
315 USD
You need to retrieve emails from the [email protected] mailbox via the Gmail API on the website (PHP). The task is only to receive new emails, I will handle the processing myself. PHP ∙ 5 proposals |