Run mysql query from php

Question

I am trying to run a MySQL query from a PHP script like this:

$q = "
UPDATE
  cf_ab_companies, inndata200
SET
  cf_ab_companies.col_158 = inndata200.AFakt_10_Fast_renhold, 
  cf_ab_companies.col_159 = IF ( inndata200.Startdato = "01.01.3000 00:00" OR inndata200.Startdato = "01.01.2000 00:00", NULL, str_to_date(inndata200.Startdato, '%d.%m.%Y')), 
  cf_ab_companies.col_160 = IF ( inndata200.Sluttdato = "01.01.3000 00:00" OR inndata200.Sluttdato = "01.01.2000 00:00", NULL, str_to_date(inndata200.Sluttdato, '%d.%m.%Y'))
WHERE
  cf_ab_companies.model_id = inndata200.ImportGOID;";

 mysql_query($q, $db);

But it seems that the query is not stored properly in PHP. What is the simplest way to store queries like this in PHP?

Thanks for all help

btw: your datetime stamps in your query should be surrounded by '' and not "" — Leonardo
– Leonardo, Commented Nov 28, 2013 at 14:33
php should show you an error the way you wrote it here, because you have unescaped " in your string (e.g. here inndata200.Startdato = "01.01.3000 00:00" ). So you need to at least escape them (write them as \") or use ' instead. — t.niese
– t.niese, Commented Nov 28, 2013 at 14:33
The query above works as I want in phpmyadmin. But instead I want to perform the query from a PHP script... — user2298034
– user2298034, Commented Nov 28, 2013 at 14:33

user2742371 · Accepted Answer · 2013-11-28 14:42:18Z

1

This should make it work; put slashes (\) before your quotes (") because it gets confused:

$q = "
UPDATE
  cf_ab_companies, inndata200
SET
  cf_ab_companies.col_158 = inndata200.AFakt_10_Fast_renhold, 
  cf_ab_companies.col_159 = IF ( inndata200.Startdato = \"01.01.3000 00:00\" OR inndata200.Startdato = \"01.01.2000 00:00\", NULL, str_to_date(inndata200.Startdato, '%d.%m.%Y')), 
  cf_ab_companies.col_160 = IF ( inndata200.Sluttdato = \"01.01.3000 00:00\" OR inndata200.Sluttdato = \"01.01.2000 00:00\", NULL, str_to_date(inndata200.Sluttdato, '%d.%m.%Y'))
WHERE
  cf_ab_companies.model_id = inndata200.ImportGOID;";

answered Nov 28, 2013 at 14:42

user2742371

Sign up to request clarification or add additional context in comments.

Comments

user2298034 · Accepted Answer · 2013-11-28 14:38:53Z

0

I managed to solve it by following the advice by t.niese to escape the "'s

Thanks a lot!

answered Nov 28, 2013 at 14:38

user2298034

1011 silver badge9 bronze badges

Collectives™ on Stack Overflow

Run mysql query from php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related