jacob21

Failed to connect smtp server,please check your SMTP information Error message:Socket error #10049 can not assign requested address I am getting this error. Need help

Hello abhi, You have to first include the php mailer class in your folder.

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 …

How to display thumbnail of videos using flowplayer.

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

hey its depend upon work.its range should be $150 to $300

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"

Hi, Below code is working for uploading and insertion in database. How below can be done without Without Reloading the Page. <?php session_start(); $userId=3; //stored userid of current login user from session include("../db.php"); //include db part if (isset($_FILES["csv"])) { $uploadedFile = $_FILES["csv"]; $uploadedFileName = $uploadedFile ["name"]; //name of uploaded file …

How to Use Google Analytics API for fetching Total Traffic for a month for a project. Need suggestions

Hi, Please advise which database should choose for developer and dba profile

Hi, I am trying to populate year,day and month dropdown. It working fine without <option value="">Select</option> i.e empty option. But getting wrong no of days for month selection after adding select option <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>untitled</title> <script type="text/javascript"> var numDays = { '1': 31, …

Hi, I am executing below query. db.leads.find(); How to get execution time(in milli seconds) it take.

Hi Experts, Which database is better acc to Performance factor. Need Suggestions..

Hi, I applied for google adsense 3 times but everytime got rejeted. Need suggestion for changes i.e. what should i change in my website. website name: [url]www.ihmjobs.com[/url] We did not approve your application for the reasons listed below. Issues: - Page type --------------------- Further detail: Page type: Your website is …

Hi, I am working on google charts.Below code is showing tooltip in case of core graph. I am trying to show tooltip in case of Table chart. need sugestions corechart code: <html> <head> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawVisualization); function drawVisualization() { data = new google.visualization.DataTable() data.addColumn('string', …

Hi, I applied for google adsense 3 times but everytime got rejeted. Need suggestion for changes i.e. what should i change in my website. website name: <snip> We did not approve your application for the reasons listed below. Issues: - Page type --------------------- Further detail: Page type: Your website is …

How to make HTML Page Full screen?? With "full screen" I mean that it should take all the space of user's screen,just like when we watch a video with the full screen model. I do not want the task bar/menu bar of the browser window display. Any suggestions??

Hello, I am new in PHP.Please tell me how to implement API in php. Thanks

Hello i want to send bulk sms.In developer API this code is given. where should i use that code. WAITING FOR HELP. A sample HTTP API Call for Single Recipient would be: [url]http://www.abulksms.com/pushsms.php?username=acs&password=your_password[/url] &sender=mysenderid&cdmasender=mycdmasenderid&to=myrecipient&message=Hello A sample HTTP API Call for Single Recipient with Scheduling (4th January 2009 at 3:30 PM) …

Hi, i am inserting data from CSV file in mysql. I am trying to skip ist row of CSV file as it contains headings. need suggestions??

Hi, I am using below PHP script for insertion in mysql table from CSV file. Below code is working fine but i am trying to leave first row of CSV as it contains heading for data. need suggestions as it is reading from very first row. <?php //connect to the …

I want a Jquery Popup Form which will appear on Page Load but only one time (for newsletter purpose). After filling form.. I want to store values into a table.

Hi, when i click on a link,its showing an extra shadow after clicking on linking text. Need suggestions.

You need to take SMS pack & api for sending SMS from SMS provider.

Hi, I want to check query execution time. I used microtime(),time() but not getting accurate result. I also read about mysql slow_query_log but not able to find how to change settings in PHPmyadmin. Need suggestions

Hi, my website svnnews.in is hacked yesterday. Now its showing some hackers messages. I need my website back.Need suggestion to make my website hack free.