There is a table that contains a VARCHAR type field with the text one+two , when you try to delete it with the DELETE FROM my WHERE test='one+two' deletion does not occur, although the database responds with the words the query was executed successfully. The plus symbol is removed from the field and the query, and this query is processed normally. The problem is observed only with the hoster, there are no such problems on the local test server ...

What can this be connected with?

  • Can you describe in more detail how the request is executed? In the console, in some client, in your program? - cheops
  • @cheops, seemingly enough information. The table is written with the statement $result = mysql_query("INSERT INTO services (service, price) VALUES ('$_POST[service]', '$_POST[price]')"); I delete $result = mysql_query("DELETE FROM services WHERE service=$_GET[del]"); if plus symbols are sent to the service field, the deletion does not occur. and what needs to be clarified to complete the full picture? - perfect
  • Strangely, your $ _GET [del] parameter is not wrapped with quotes in the query "DELETE FROM services WHERE service = $ _ GET [del]", the plus sign will be interpreted as + SQL query language. - cheops
  • I also thought but everything is fine, he is wrapped in the link itself. in single quotes - perfect
  • @cheops link looks like this: ... service.php? del = 'one + two' - perfect

0