jacob21

How I can send emails to gmail, yahoo, etc. from localhost. I am using XAMPP in windows. What are the necessary changes in php.ini ??

Hi, below code is extracing title,keywords,descrption,links. Need suggestions to find out IP address, Load Time, HTTP Status <?php function file_get_contents_curl($url) { $ch = curl_init(); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); $data = curl_exec($ch); curl_close($ch); return $data; } $html = file_get_contents_curl("http://servicesonclick.com/"); //parsing begins here: $doc …

Hello all, i am stuck on this.. i want to be able to play a video from a mysql database. Currently i can upload the video to mysql (name, type, size, content) and download the file. i have a media player that shows a video, but i have to use …

Chats table maintain chat history b/w users and agent.Type(0,1,2) indicates start and end point of chat by user/agent. Please suggest how we cam give each chat a unique session For Example Chat b/w company_id(5969) and user_id(67) has 1 unique chat id. Not Sure Is it possible in query or have …

Hi, By using **group by c3.source**,getting below result. I am trying to add condition in group by clause such that 3 rows should come 1)0+3 source result should merged 50+48 52+75 99+102 2) 4 source result contains ids having source 4 and url like '%daniweb%' source 0_to_7_days 7_to_14_days more_then_15_days 0 …

I have a column name descrption in a table.. descrption contains multiple rows like claim for my new mercedes purchase my new car ------ ----- I am trying to explode each row and save each entery in a new column. claim :save in split1 for:save in split2 my:save in split3 …

Hi, Need suggestion for a query. I am trying to get count(c3.id) for all days of feb. As in cs.created_at some dates are missing.How can i use below clause. **group by day(cs.created_at)** something like group by day(month(cs.created_at)) not working.. select count(case when cs.id IN(select max(id) from complaint3_status where complaint_id=c3.id and …

Hi, Need suggestion for sql query. I have 2 tables user user_status user: id,name user_status=id,user_id,status_type,status_value user_status stores multiple status_type and status_value.for 1 user there can be multiple rows I am trying to get all users having who are not blocked i.e user_status table dont have status_type(10) and status_value(11)

Hi, Need Suggestion for a query user_id source I need all user_id having source value=1,2 but source 2 user should have url like '%facebook%'

Hi, Can we use count inside case statement. Need suggestions.. Error: ER_INVALID_GROUP_FUNC_USE: Invalid use of group function select COUNT(case when count(c3.id)>1 then c3.id end) as more_then_one ...................... ...........................

Complaint table id company_id user_id source id=coplaint_id user_id=user which filed complaint company_id=complaint againt company source=source of complaint I am trying to get user_id who have filed complaint via same user_id and against same company. one user can filed multiple complaints against same/different company

Hi, I have 5 tables..a.b,c,d,e While doing equi join : 1)a.id=b.id, b.id=c.id, c.id=d.id, d.id=e.id a.id=c.id, a.id=d.id b.id=d.id How internally equi join works.should i need all PK to Join Could you suggest me some tutorial which shows how internally works.

Hi, Is there any tool that extract below from gmail and save in to csv. Name of Person to: Email id cc: Email id Time stamp - DD/MM/YYYY URL's in the email

Hi, below queries gives two rows like category_name high_value_complaints category_name high_value_duplicate_complaints I am trying to merge both queries category_name high_value_complaints high_value_duplicate_complaints I tried to join both tables but its giving category_name high_value_complaints category_name high_value_duplicate_complaints Need suggestions select category_name, count(distinct complaint3.id ) as high_value_complaints from complaint_category,assignment3,user3,complaint3_details, complaint3,complaint_tag ct where complaint3.complaint_category_id=complaint_category.id and …

Hi, I stored hindi data in my my sql table through Php form. While fetching,it is not coming in hindi but some unusual symbols like गिरधर गोपाल रायतानॠis coming. using below code also [CODE]mysql_query('SET character_set_results=utf8'); mysql_query('SET names=utf8'); mysql_query('SET character_set_client=utf8'); mysql_query('SET character_set_connection=utf8'); mysql_query('SET character_set_results=utf8'); mysql_query('SET collation_connection=utf8_general_ci'); [/CODE] Need help..

Hi, I have a table: user uid status 1 1 2 1 3 1 4 2 5 2 6 1 7 2 8 1 9 3 10 2 I am trying to fetch data for below logic: 1) fetch top 6 rows having status=1 2) if status=1 has less then …

Hi, I have around 4 lakhs email id data(In CSV). I want to change status of above emailids. Could i run a simple update query or do something more. Need Suggestions

Below tables :I am trying to calculate **openLeadsCount** having status 1 I tried but getting wrong results SELECT COUNT(lead.id) FROM lead JOIN lead_status ls WHERE ls.lead_id=lead.id AND ls.id=(SELECT MAX(id) FROM lead_status lst WHERE lst.status=1 ) Lead table: id created_on 1 2014-1-13 2 2014-1-18 lead_status table id lead_id created_on lead_status 1 …

Hi, I am using timestamp datatype for storing date..and value of column is like 2013-12-31 T 23:59:59.000Z For query SELECT * FROM a WHERE created_on BETWEEN '20131201' AND '20131231' SELECT * FROM a WHERE created_on >= '20131201' AND created_on <= '20131231' Which will give right result??

Hi, I am trying to merge below two queries in a single query such that company_id,company_name,noOfOpenTickets,noOf PendingTickets Need suggestions?? No Of open Tickets: select c.company_id, (select company_name from company where id=company_id) as companyName,count(s.complaint_id) as noOfOpenTickets from complaint3 c ,complaint3_status s where s.id =(select max(d.id) from complaint3_status d where d.complaint_id =c.id …

Hi, Need Suggestion for hiding a div from 9Pm to 9Am.

Hi, I am trying to get last updated time of database in mysql. need suggestion???

Hi, Below code working fine in firefox,but not working in IE,Chrome,Opera. Need Suggestions. <div class="topheading"><b>Headlines:</b></div> <div id="marquee_wrap"> <marquee direction="left" scrollamount="2"> <?php include('../db.php'); $headlineNewsQuery=mysql_query("SELECT * from svn_headline order by newsid DESC LIMIT 0,8 "); while($headlinenewsresult=mysql_fetch_assoc($headlineNewsQuery)){ //$newsHeadline=$headlinenewsresult['newsheadline']; ?> <li><img src="images/maq-bullet.png" /><?php echo $headlinenewsresult['newsheadline']; ?> </li> <?php }?> </ul></marquee> </div>

Hi, I am working on a news website.I am trying to add fb share/like, twitter share, google plus button for each news. could u please give me direction for starting above. Is there any plugin?? it is same as in daniweb i.e we can share each post on social networks

programmers help me i have a problem for my study issue, if i ask you to develop a program that contain a database and using php scripting language how much it will cost for the whole development. also it is an online system. example Nutrition Information System. i hope that …

I am using below query for fetching result using union of two tables. I am trying to get total number of records after union of two tables Need Suggestions. ` SELECT a.* FROM svn_headline a where a.newstypeid=2 UNION SELECT b.* FROM svn_crimenews b where b.newstypeid=2 order by newsdatetime desc SELECT …

$newtypeid=$_REQUEST['newstype']; $action = (isset($_REQUEST['action'])&& $_REQUEST['action'] !=NULL)?$_REQUEST['action']:''; if($action == 'ajax'){ echo "newtypeid is".$newtypeid; -------------- //some stuff here } How to get $newtypeid value inside if statement.

Hi, I need suggestions regarding getting rank of website from search engine.For example: I search php tutorial in google w3school get 1st rank,php.net get 3rd rank How i can get above rank Need help!!! Thanks

Hi, I am working on a web application having more then 5 lakhs users accessing pdf file from server. Each time a pdf is loaded from server which may consume network bandwidth(our assumtion). Need suggestions for how can we restrict only 100 or any number of users at a time …

Hi, Need Help regarding a query. I want to search all empName from emp table whose name 3rd letter is "s"