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 is doing approximately same thing but I am not sure how they got this using PHP.
Can anyone suggest the similar kind of PHP...
rahulephp
Last Activity: Nov 9 '11, 08:06 AM
Joined: Sep 30 '09
Location:
-
rahulephp started a topic Does Google Transliteration (not Translator) support German, Swedish language??in GeneralDoes Google Transliteration (not Translator) support German, Swedish language??
Hello,
I found Google Transliteration , a very good tool to reproduce the sounds of a sentence in a different language.
Reference:
http://code.google.com/apis/language/transliterate/v1/multilangtransl iteration.html
http://www.google.com/transliterate/
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... -
Thank you for taking part in this.
Sorry, their was a typo, You need to put a COMMA after e.clean_modelno ,(here)
I am getting the expected results that i want but it takes huge time to make group of 100000 products by their clean_modelno, publishercatego ryCode:e.publishercategory, e.clean_modelno, MAX(price) as max_price, MIN(price) as min_price,
You know... -
Thank you for taking part in this.
Sorry, their was a typo, You need to put a COMMA after e.clean_modelno ,(here)
I am getting the expected results that i want but it takes huge time to make group of 100000 products by their clean_modelno, publishercatego ryCode:e.publishercategory, e.clean_modelno, MAX(price) as max_price, MIN(price) as min_price,
You know...Leave a comment:
-
How to speed up the Group By Clause for a large 3GB database?
How to speed up the Group By Clause for a large 3GB database.
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 without using LIMIT.
We can’t use LIMIT as we need all of the entries from a category to be show in the filters section.
We have a Dedicated Linux server with 4GB... -
What is the best mysql configuration of My.cnf?
Hi all,
First of all I am new with server using.
Below my virtual private server details:
- 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
Due to 3GB of database size, server may not respond some times and working very slow even if good server configuration.... -
Ohh. I am sorry if you couldn't understand.
Let me explain,
Description from argos is always good as compare to buy.
In the same way Argos > buy > amazon > ebay > Next
I want to select Description from argos if present else from buy else from amazon.
It mean,
Code:
...Code:if(programname = Argos ) { description = description; //Argos description } elseif(programnameLeave a comment:
-
GROUP BY clause and CASE statement – need help
I have a table with 4 columns
Table name = products
Column name = product_id, product_program name, product_title, model_number
When I use GROUP BY with model_number, it alway returns me the info of product (ebay) which comes first in the queue.
But i want to get the title from 'argos' if not null else 'buy' if not null etc.
The below query doesn't works for me.
...Code:SELECT *,
-
MYSQL - GROUP BY clause at Professional Level
How to fetch the "name" FROM programname = "Buy" and description which has maximum words using GROUP BY??
I have 6 columns with thousands of product entries:
Table name : eproducts
Columns : product_id, programname, name, description, clean_modelno
Ex. Products Entries:
product_id : 5001
programname : argos
name : Toshiba 32RV753B
description : By... -
MYSQL - How to use UPDATE with IF-ELSE condition
I have three columns - id, programname, status
I wanted to use UPDATE with IF condition something like this:
...Code:UPDATE elec_products IF(programname ='Argos') ( SET status = 1 ) ELSEIF(programname ='sify') ( SET status = 2 ) ELSE ( SET status = 3 ) ENDIF WHERE programname IS
-
Mysql LIKE Search query - How to get most accurate row first.
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) -
What’s missing with Switch Statement?
In below switch statement, it should have to print only "T","E","S" characters as string "testing" contains these words.
But it is printing all characters including "X" and "Z".
I can’t use "break;" because it will break operation after first case. (After matching "T" with word "testing") but I want to continue the operation even after every... -
How to parse XML product feed using PHP??
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 product feed???
(Actually, I need each product data in array to be stored into the database)
Thank you in advance. -
Did, works excellent, thanks a lotLeave a comment:
-
How to use UPDATE with SELECT???
Mysql - How to use UPDATE with SELECT???
I have two tables:
1) products_catego ry
-cat_id
-cat_name
2) related_categor y
-rel_cat_id (exaclty same as products_catego ry.cat_id==rela ted_category.re l_cat_id)
-rel_cat_name
products_catego ry table
related_categor y table
I want to get cat_name from products_catego ry... -
I got the solutions in another way,
Here it is:
The output is separated by "||"...Code:<?php $titles = Array('Sony DCSW380B 14MP Camera', 'Casio 10MP Camera EX-Z3/3', 'Panasonic Lumix Camera DMC-G1 12MP'); foreach($titles as $item) { if(preg_match_all('/\b([A-Z0-9\/\-\+]+)\b/', $item, $tmp)) print implode('||', $tmp[1]).'<br />'; } ?>Leave a comment:
-
How to seperate Model Numbers from a string
Can anyone please let me know how to separate Model Numbers from a string
For Ex 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 12MP" OR "DMC-G1"... -
You are right, you should use mod_rewritten URLs for better performance. You can also send me URL of your website as PM so that i would have a look on that....Leave a comment:
-
I'm thankful for your good response on this but now i want to close the topic here.
Thanks once againLeave a comment:
-
Hey HaLo2FrEeEk,
if you are going to rewrite your entire site to use mod_rewritten URLs and if your website has ranked in SERP for good keywords then think it once. The URLs of all you website pages will be changed and the URLS will suppose to be new pages. And in that case you'll lost your previous ranking....Leave a comment:
No activity results to display
Leave a comment: