suresh64633

Hi I want to display time as per client locations. And for this i need client Time Zone to set through date_default_timezone_set() function. OR any one having another way will be appreciated. Thanks!!

Dear All, I want to make image from 72 dpi to 300 dpi with PHP (ImageMagick). Please guide me urgently. Thanking you,

Hi Guys I don't know, this is the correct category to post this issue. I am integrating Shindig in my Local Machine which is on window OS. I followed the instruction given as per http://www.chabotc.com/guides/shindig_install/. It gives me error as: Error Error parsing gadget xml:  -^ Fatal Error 4: Start tag expected, '<' not found Line: 1 Column: 1 Thanks.

Thanks salathe It is really usefull.

Hi guys I got the query # OPTION ONE: To find 3rd highest select * from salary e where 3 =(select count(distinct salary) from salary where e.salary<=salary) # OPTION TWO: It find only 2nd highest. SELECT max( p1.sal ) FROM jos_salary p1, jos_salary p2 WHERE p1.sal < p2.sal

Hi, Do PHP have Exception Types? If yes, what are they? Thanks!!

Hi Guys How do i get 2nd highest values(say salary) without using Sub-query or Limit? Many Thanks.

Hi, Try this regular expression. SELECT '1234/56/78/sdf' REGEXP '[0-9]{4}/[0-9]{2}/[0-9]{2}/[a-z]'; Thanks

Hi, I want first two alphabetically. Thanks

Suppose i have a table "city" which store detail as city_id ,state_id and city name city_id state_id city_name 1 1 APO 2 1 FPO 5 1 Bethel 6 3 Indian 7 3 Anchorage 8 3 Anch 9 3 Fort Richardson If i fire a query like SELECT * FROM city GROUP BY state_id It will show single record of each group like: city_id state_id city_name 1 1 APO 5 3 Bethel But i want it must show 2 record of each group like: city_id state_id city_name 1 1 APO 2 1 FPO 6 3 Indian 7 3 Anchorage

thanks

How can i convert my time string "10:00 PM" to "22:00:00";

Thanks buddy Now it is working!!

FYI

I set the Environment Variables (variable Name: console AND variable value ='C:\wamp\www\cake\cake\console') and restart my PC. And run following command on DOS prompt.I am getting this error. C:\wamp\php>php c:/wamp/www/cake/cake/console/libs/bake.php Fatal error: Class 'Shell' not found in C:\wamp\www\cake\cake\console\libs\bake. php on line 36 C:\wamp\php>

Hi ALL I am new in CakePHP and want to generate files from console in windows platform. I have WAMP in C:/wamp/www/. Please help me to generate files form DOS Prompt. Thanks!!

Thanks artacus

i try to use like this but not working SELECT STR_TO_DATE( '09:30:17 PM', '%h:%i:%s' ) ; result is "09:30:17" it should be 21:30:17 Thanks

Hi I have a table in which time is store as "1.00 PM" in varchar datatype. Now i want to sort records with this fields. As it is varchar it does not work properly. I need any function [AS strtotime() in php] by which i can convert this time to 24 hours format so i can sort it easily. Thanks!!

Hi, try WEEKOFYEAR(date) in Mysql. Thanks

i got this http://www.sitepoint.com/blogs/2007/05/14/easy-database-schema-diagrams-with-dbvisualizer/

One of my senior told me that we can send mail through Triggers.Now i am wondering how it can be possible!!

Can we send mail through Mysql ?

Hi Can u try with this: $result = mysql_query ("SELECT * FROM product_table WHERE product_name = REPLACE('".$keyword."','-','') or product_name LIKE '%$keyword%'"); thanks

Hi, Correct the query like this: SELECT * FROM product_table WHERE product_name = REPLACE('AC-3A','-','') or product_name LIKE '%AC-3A%'; thanks