Sign up to connect with ehpratah and gain access to their complete profile
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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. …
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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() …
  • Member Avatar
    ehpratah

    Replied To a Post in Display Array

    Hi never find got it already.thanks!
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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() …
  • Member Avatar
    ehpratah

    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() …
  • Member Avatar
    ehpratah

    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() …
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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
  • Member Avatar
    ehpratah

    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/ …
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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; } …
  • Member Avatar
    ehpratah

    Replied To a Post in PHPExcel Grandtotal Error

    Anyone has an idea?
  • Member Avatar
    ehpratah

    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/ …
  • Member Avatar
    ehpratah

    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/ …
  • Member Avatar
    ehpratah

    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/ …
  • Member Avatar
    ehpratah

    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/ …
  • Member Avatar
    ehpratah

    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/ …
  • Member Avatar
    ehpratah

    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/ …
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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.
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    Replied To a Post in PHPExcel Generate 2 or more Excel File

    Anybody have an idea whats wrong im doing?
  • Member Avatar
    ehpratah

    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 …
  • Member Avatar
    ehpratah

    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 …

The End.