I have 4002 commands similar to mysql_query("INSERT INTO `{$prefix}games` (gam_id, gam_cat_id, gam_swf, gam_title, gam_thumb_url, gam_swf_width, gam_swf_height, gam_desc, gam_views) VALUES (19,7,'152.swf','Adventure Elf','152.png',549,399,'Run about the buildings picking up presents and avoid penguins.',0)") or report(); Code (markup): I want the png files or images files i.e. gam_thumb_url to extracted and pasted into the db or txt file alone. can it be done?
You could use a trigger on each insert to put the image into another table each time there is an insert. You may need to do some research and testing to get it to work properly, but it should be easier and more reliable than a code-level solution. Here's some info on creating a trigger: http://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html http://www.databasedesign-resource.com/mysql-triggers.html