-
Marked Solved Status for Query running slow?
Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to … -
Replied To a Post in Query running slow?
Hi Hericles, > What is the query trying to do? The query is fetching all the record frm 3 tables using *inner join* and I am using pagination displaying it. … -
Created Query running slow?
Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to … -
Began Watching Query running slow?
Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to … -
Marked Solved Status for Display Array
Hi Guys! I cant find a way to show my data array the way i need it to be hope you can help me. i already tried using array_push(), json_encode() … -
Replied To a Post in Display Array
Hi never find got it already.thanks! -
Replied To a Post in Display Array
Hi Diafol! Thanks for that but how can i remove the "" on the numbers? `[["Boat + Cab","3"],["Bus + Boat","41040"],["Bus + Boat + Cab","840"],["Bus Only","14343.75"],["Door to Door","674973.75"]]` the format should … -
Edited Display Array
Hi Guys! I cant find a way to show my data array the way i need it to be hope you can help me. i already tried using array_push(), json_encode() … -
Created Display Array
Hi Guys! I cant find a way to show my data array the way i need it to be hope you can help me. i already tried using array_push(), json_encode() … -
Began Watching Display Array
Hi Guys! I cant find a way to show my data array the way i need it to be hope you can help me. i already tried using array_push(), json_encode() … -
Began Watching Mysql Count Number of rows
Dear Member, I'm using MYSQL 5.6 and have 3 tables: 1. Customers (Cutomer_id, Customer_Name) 2. Order1 (Order_Id1, Customer_id) 3. Order2 (Order_Id2, Customer_id) I need to write a query to count … -
Replied To a Post in Mysql Count Number of rows
Try looking at *Inner join* and *count()* http://www.w3schools.com/sql/sql_join_inner.asp -
Marked Solved Status for PHPExcel Grandtotal Error
Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ … -
Replied To a Post in PHPExcel Grandtotal Error
WOW thats it? holycow im stuck on that for 2 days and you answered it very casually with > Yes exactly put line 17-18 inside while loop. Where are you … -
Replied To a Post in PHPExcel Grandtotal Error
Hi! thank you for giving your inputs on this matter. To answer you on > Before line number 100 that is before ending while loop break the loop break; } … -
Replied To a Post in PHPExcel Grandtotal Error
Anyone has an idea? -
Edited PHPExcel Grandtotal Error
Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ … -
Edited PHPExcel Grandtotal Error
Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ … -
Edited PHPExcel Grandtotal Error
Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ … -
Edited PHPExcel Grandtotal Error
Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ … -
Created PHPExcel Grandtotal Error
Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ … -
Began Watching PHPExcel Grandtotal Error
Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ … -
Marked Solved Status for PHPExcel Generate 2 or more Excel File
Hi Everyone! Can anybody point me to the right direction or check what am i doing wrong. Im trying to export data from php to excel using phpexcel( which is … -
Replied To a Post in PHPExcel Generate 2 or more Excel File
Got it! Line 45 is the one causing the problem..i just remove that line and everything working fine. -
Replied To a Post in PHPExcel Generate 2 or more Excel File
Hi JKON! this is the dump file for the client name CREATE TABLE IF NOT EXISTS `accounts_info` ( `aid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `email` varchar(50) NOT … -
Replied To a Post in PHPExcel Generate 2 or more Excel File
also i'll post again the sql dump here without the contact info when i reach home. sorry im on mobile -
Replied To a Post in PHPExcel Generate 2 or more Excel File
Hi jkon sorry for the late response. my sql dump was cleaned by a mod because of the sensitive data that was posted thats why it didn't match.basically what im … -
Replied To a Post in PHPExcel Generate 2 or more Excel File
Anybody have an idea whats wrong im doing? -
Replied To a Post in PHPExcel Generate 2 or more Excel File
Also this are the sql dump if you wanna check it:) CREATE TABLE IF NOT EXISTS `accounts_info` ( `aid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `email` varchar(50) NOT … -
Replied To a Post in PHPExcel Generate 2 or more Excel File
Hi jkon i am still orienting my self to pdo and still getting the feel of it.dont know yet most of the tricks and other stuffs. The *"../includes/pdo_config.php"* is just … -
Replied To a Post in PHPExcel Generate 2 or more Excel File
anybody has an idea what am i doing wrong? when i try to creat a excel file base on the list of name i got from the reservations table using … -
Replied To a Post in PHPExcel Generate 2 or more Excel File
notice the select query on both script. I dont know if the problem is the while loop or the foreach.. -
Replied To a Post in PHPExcel Generate 2 or more Excel File
But when i try to get a specific resfor its working the way it should be Working script <?php error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : … -
Created PHPExcel Generate 2 or more Excel File
Hi Everyone! Can anybody point me to the right direction or check what am i doing wrong. Im trying to export data from php to excel using phpexcel( which is … -
Began Watching PHPExcel Generate 2 or more Excel File
Hi Everyone! Can anybody point me to the right direction or check what am i doing wrong. Im trying to export data from php to excel using phpexcel( which is … -
Marked Solved Status for Ubuntu and Zorin not opening thunderbird and firefox?
Hi Has anyone of you having a problem opening firefox , google chrome and thunderbird since yesterday? coz almost all of our unit that is running in ubuntu and Zorin … -
Replied To a Post in Ubuntu and Zorin not opening thunderbird and firefox?
Foud the problem. it seems that the on access scanning of sophos is the one causing of the bugs. -
Created Ubuntu and Zorin not opening thunderbird and firefox?
Hi Has anyone of you having a problem opening firefox , google chrome and thunderbird since yesterday? coz almost all of our unit that is running in ubuntu and Zorin … -
Began Watching Ubuntu and Zorin not opening thunderbird and firefox?
Hi Has anyone of you having a problem opening firefox , google chrome and thunderbird since yesterday? coz almost all of our unit that is running in ubuntu and Zorin … -
Began Watching Error non-SMTP ACL
Hi guys , I have a pretty big problem and I don't know how to fix it. I have a contact page that I did not work on my web … -
Replied To a Post in Error non-SMTP ACL
Hi as **cereal** been pointing out you just need to add your "phpmailer " /sending code on your form action like `<form action="phpmailer.php" method="post">` after that you need to pass … -
Replied To a Post in How to send auto emails 2 days before PHP
can you run this script? <?php echo phpinfo(); ?> please read http://php.net/manual/en/function.date-diff.php to better understand why you are getting that error message. Another thing your date_default_timezone is not correct please … -
Replied To a Post in How to send auto emails 2 days before PHP
According to the php [manual](http://php.net/manual/en/function.date-diff.php), date_diff is only available in PHP 5.3+ so thats why you are getting a fatal error. check the version of your php by echoing `phpinfo();` -
Replied To a Post in How to send auto emails 2 days before PHP
please be more specific what error are you getting? the sample i gave you is working perfectly on my side without any glitch. -
Replied To a Post in How to send auto emails 2 days before PHP
dont put your if statement in a straight line if you have a comment on it. if($diff=='2'){ //send email }else { //do nothing } ?> -
Replied To a Post in How to send auto emails 2 days before PHP
what error? -
Replied To a Post in How to send auto emails 2 days before PHP
Your First script will work. you just need to make a cronjob for it to send the email automatically. $currentdate=date_create("2014-06-15"); $duedate=date_create("2014-06-13"); $diff=date_diff($currentdate,$duedate); echo $diff->format("%a"); if($diff=='2'){ //send email }else{ //do nothing … -
Replied To a Post in How to send auto emails 2 days before PHP
No its not. the pc needs to be turned on for the task scheduler to work. the best option you have is yo use a cronjob on your webserver that … -
Began Watching How to send auto emails 2 days before PHP
I want to create a webpage which will automatically send an email before 2 days. <form action="try.php" method="post"> <p>Date From : <input type="date" name="date1" /></p> <p>Date To: <input type="date" name="date2" … -
Replied To a Post in How to send auto emails 2 days before PHP
Hi First you must create a script that will check your DB if if the duedate is 2 days before. a simple select query will work.something like `SELECT * FROM …
The End.