rahulephp

	Mysql - How to use UPDATE with SELECT??? 13 Years Ago 4 Years Ago Share on Facebook Share on Twitter Share on LinkedIn [B]Mysql - How to use UPDATE with SELECT???[/B] I have two tables: [B]1) products_category[/B] -cat_id -cat_name [B]2) related_category[/B] -rel_cat_id (exaclty same as products_category.cat_id==related_category.rel_cat_id) -rel_cat_name [B]products_category table[/B] [IMG]http://www.ephpsolutions.com/scud/rrr/product_category.gif[/IMG] [B]related_category table[/B] [IMG]http://www.ephpsolutions.com/scud/rrr/related_category.gif[/IMG] I want to get cat_name from products_category and want to store in rel_cat_name in related_category tabel. and the query should … Databases mysql 0 3 54K
	How to change the foreground color of animated GIF image using PHP??? 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn From last few days I am struggling to achieve this. For some reason, we need to change the Foreground (display) color of animated gif images without losing their animation. I am sure there should be some ways to do thing but i couldn't able to find that. A website ajaxload[dot]info … Web Development php 0 1 90
	Does Google Transliteration (not Translator) support German, Swedish language?? 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hello, I found Google Transliteration, a very good tool to reproduce the sounds of a sentence in a different language. Reference: [url]http://code.google.com/apis/language/transliterate/v1/multilangtransliteration.html[/url] [url]http://www.google.com/transliterate/[/url] It supports approx. 22 languages. Can anybody please let us know how does make it to support German and Swedish too. I cant see these languages there. … Web Development javascript 0 1 96
	How to speed up the Group By Clause for a large 3GB database. 13 Years Ago 13 Years Ago Share on Facebook Share on Twitter Share on LinkedIn [b]How to speed up the Group By Clause for a large 3GB database.[/b] I am using Group by clause for a large database having 148 columns and 5 million rows with approx 3GB of size. We need to apply the Group by clause on approx 1,00,000 rows at a time … Databases mysql 0 6 702
	Need best mysql configuration of My.cnf 13 Years Ago 13 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hi all, First of all I am new with server using. Below my virtual private server details: [LIST] []Processor : 2.8 GHz Dual Core []Processor Cores: 2 []RAM Memory : 4GB []Apache Version: Apache/2.2.3 (CentOS) []PHP Version 5.1.6 []MySQL Version: 5.0.77 []HDD: 100GB []Bandwidth: Unlimited [/LIST] Due to 3GB of … Databases mysql 0 1 122
	Mysql LIKE Search query - How to get most accurate row first. 13 Years Ago 13 Years Ago Share on Facebook Share on Twitter Share on LinkedIn On my search result page, I wanted to search for "Nintendo DS Lite - Pink" I used following code: Ex: [code] $search_text = "Nintendo DS Lite Pink"; $kt=split(" ",$search_text);//Breaking the string to array of words // Now let us generate the sql while(list($key,$val)=each($kt)) { if($val<>" " and strlen($val) > 0) … Web Development php 0 1 112
	How to parse XML product feed using PHP?? 13 Years Ago 13 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I am a php programmer but I am not so good with XML files. For a price comparison website, I need to parse the Amazons XML feed to store product data into the database. Can anyone please help me to find out such a simple script to parse Amazon XML … Web Development php 0 1 652
	how to seperate Model Numbers from a string 13 Years Ago 13 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Can anyone please let me know how to seperate Model Numbers from a string ForEx Titles: 1) Sony DCSW380B 14MP Camera 2) Casio 10MP Camera EX-Z3/3 3) Panasonic Lumix Camera DMC-G1 12MP Output would be: For 1) "DCSW380B 14MP" OR ""DCSW380B" For 2) "10MP EX-Z3/3" OR "EX-Z3/3" For 3) "DMC-G1 … Web Development php 0 3 94