Creating php script for MySql Query

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ShoutChris
Forum Newbie
Posts: 1
Joined: Wed Mar 25, 2009 11:45 pm

Creating php script for MySql Query

Post by ShoutChris »

Hi Guys

I do not have a clue where to start in turning the follow MySql query into a php script can anyone help. I am :banghead: and going :crazy: trying. The script needs to loop so all records are updated in the downloadable_link table. Any help would be great.
UPDATE catalog_product_entity_media_gallery ri, downloadable_link rri
SET rri.image_id = ri.value
WHERE rri.product_id = ri.entity_id
Cheers
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Creating php script for MySql Query

Post by requinix »

You can run that query with mysql_query.
vivianflv
Forum Newbie
Posts: 3
Joined: Thu Mar 26, 2009 2:48 am

Re: Creating php script for MySql Query

Post by vivianflv »

wow, cool.
Post Reply