Get sql query working in php ?

[Glenskie]

Hi how can i get this sql query to work in php ? this query worked in navicat 

 

 

/* API */ 
INSERT IGNORE INTO ps_search_index (id_product, id_word, weight) 
SELECT DISTINCT Product_ID, Product_ID + 5000 'id_word', '1' 
FROM ps_product_part_number 
WHERE API != '' AND API IS NOT NULL;
INSERT IGNORE INTO ps_search_word (id_word, id_shop, id_lang, word) 
SELECT DISTINCT Product_ID + 5000 'id_word', '1', '1', API  
FROM ps_product_part_number 
WHERE API != '' AND API IS NOT NULL; 

I GOT THIS FAR

"INSERT INTO ps_search_index (id_product, id_word, weight)
SELECT DISTINCT Product_ID, Product_ID + 5000 AS id_word , '1'
FROM ps_product_part_number
WHERE API != '' AND API IS NOT NULL"
"INSERT INTO ps_search_index (id_product, id_word, weight)
SELECT DISTINCT Product_ID, Product_ID + 5000, '1'
FROM ps_product_part_number
WHERE API != '' AND API IS NOT NULL"

Edited January 27, 2014 by Glenskie

[requinix]

That's two queries.

 

Execute each one individually using your preferred database-handling code, such as PDO, mysqli, or whatever your framework provides (if you are using one).

[Glenskie]

yes its two querys but it is not working 

[davidannis]

You need to write php code. Depends what database you are using and what method you want to use. Assuming that you are using mysql you can start here: http://php.net/mysqli Other databases are supported by php and documentation is available on php.net.

[cyberRobot]

yes its two querys but it is not working 

 

What does your code look like?