suresh64633
Members-
Posts
61 -
Joined
-
Last visited
Never
Everything posted by 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, Do PHP have Exception Types? If yes, what are they? Thanks!!
-
Hi, Try this regular expression. SELECT '1234/56/78/sdf' REGEXP '[0-9]{4}/[0-9]{2}/[0-9]{2}/[a-z]'; Thanks
-
Two records in each group with GROUP BY clause.
suresh64633 replied to suresh64633's topic in MySQL Help
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
-
Converting 12 Hours Format to 24 Hrs Format
suresh64633 replied to suresh64633's topic in Javascript Help
thanks -
How can i convert my time string "10:00 PM" to "22:00:00";
-
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>
-
[SOLVED] change format from 12 hrs to 24 hrs!!!
suresh64633 replied to suresh64633's topic in MySQL Help
Thanks artacus -
[SOLVED] change format from 12 hrs to 24 hrs!!!
suresh64633 replied to suresh64633's topic in MySQL Help
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