manojjena1982

Hi! Akl I want to upload a file sizeed around 2GB. Could you help me? Thanx in advance

Hi! all, I want difference between two date which results into HH:MM:SS. date format: MM/DD/YYYY HH:MM:SS suppose there are two date 09/14/2009 13:00:00, 09/18/2009 13:00:00 the difference between the above will return not 4 days rather difference in 96:00:00 . thanks in advance Regards, Manoj

Hi! All I am working with database mysql5.0 on my system. But when i upload every thing in web it is not recognising host as [url]http://205.178.146.79/[/url] and giving Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'http' (1) in /data/19/1/55/45/1870534/user/2032167/htdocs/music/LoginSystem.class.php on line 112 Unable to connect to MySQL Please help me …

Fatal error: Call to undefined function mcrypt_module_open() Please help me to fix it.

Hi! thr, I am uploading a file in to server. At the time of downloading, it should show "view as html" as google does. thanx in advance. Manoj

I have a table name Project(id,projectid,date) ----------------------------------------------------------- id | projectid | date 1 | 9 | 2009-02-03 2 | 9 | 2009-03-04 3 | 9 | 2009-04-05 i need a query which will return me the recent date of that project id. query will return: 3 | 9| 2009-04-05

Hi! All I am new to this feild. I am no prior knowledge in any flash. But in my company i got this assignment. My deadline is one week. Please help me out. Manoj

Please help me to track it out. how do i use facebook login information to validate a user in my site and also i want to extract some information from facebook about that user.

Hi! all Let me explain the problem:- I have two tables A(aid,aname,adesc),B(bid,aid,bdesc). I want a query which will extract all records of 'aid' in 'B'. means aid bid aname bdesc 1 1 qw eeg 2 null re null 3 4 sd v tyuy 4 null dffg null Hope to get …

Hi! I think the function that u called do not able fine the return type, You can try this out, May it work. ListNode* tmp = (ListNode*)validate(pos);

Hi Vele, You can try this one-- select id, title from data where title LIKE '%PHP developer%' union select * from data The above query will return the exact string with all other rows in the database. select id, title from data where title LIKE '%PHP developer%' union select * …

Hi! Try this one but go through the query and apply as you need. for any problem regarding this bug me. [code=sql]select tblbcategory.bCategoryId,tblbcategory.bCategoryName, if(COUNT(tbltopic.TopicId), COUNT(DISTINCT tbltopic.TopicId),'No Topics') as TotalTopics, if(COUNT(tblcomments.CommentId), COUNT(DISTINCT tblcomments.CommentId),'No Comments') as TotalComments, if(MAX(CONCAT(DATE_FORMAT(tblcomments.DatePosted,'%Y%c%d%h%i'), tblcomments.CommentDescription)), SUBSTRING(MAX(CONCAT(DATE_FORMAT(tblcomments.DatePosted,'%Y%c%d%h%i'), tblcomments.CommentDescription)),12,25),'') as description, if(MAX(CONCAT(DATE_FORMAT(tblcomments.DatePosted,'%Y%c%d%h%i'), tblcomments.UserEmail)), SUBSTRING(MAX(CONCAT(DATE_FORMAT(tblcomments.DatePosted,'%Y%c%d%h%i'), tblcomments.UserEmail)),12), 'No user posted last') as …

Hi! Try this.. [code=sql]create table data2 as select rpad(name,10,' ') as name from data select length(name) from data2[/code] here i am creating a table with the select statement to find out the length on other table. So, its coming as 10. I think it may help you manoj

Hi! Try this [code=sql]select if(name='Jon',replace(name,'Jon',''),name) as name from data[/code] Regards, Manoj

Hi All! I am new to web-development. In my company i get a project i.e based on action script. I have no idea on this. But inthis down time i have no other choice left. Could anybody help me out from this critical situation? Don't hesitate to suggest me anything. …

I am writing a stored procedure in which i want to catch all the exceptions.So. i need how to catch the error code from an exception.