Databases
Member Avatar

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 …

Databases
Member Avatar

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 …

Topic by ehpratah

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. …

Databases
Member Avatar

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 …

Databases
Member Avatar

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 …

Web Development
Member Avatar

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() …

Web Development
Member Avatar

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() …

Topic by ehpratah

Hi never find got it already.thanks!

Web Development
Member Avatar

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() …

Topic by ehpratah

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 …

Web Development
Member Avatar

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() …

Web Development
Member Avatar

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() …

Web Development
Member Avatar

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() …

Web Development
Member Avatar

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 …
php
Web Development
Member Avatar

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 …
Topic by ribrahim

Try looking at Inner join and count()

http://www.w3schools.com/sql/sql_join_inner.asp

php
Web Development
Member Avatar

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/ …

Web Development
Member Avatar

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/ …

Topic by ehpratah

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 …

Web Development
Member Avatar

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/ …

Topic by ehpratah

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;
} …
Web Development
Member Avatar

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/ …

Topic by ehpratah

Anyone has an idea?

Web Development
Member Avatar

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/ …

Web Development
Member Avatar

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/ …

Web Development
Member Avatar

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/ …

Web Development
Member Avatar

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/ …

Web Development
Member Avatar

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/ …

Web Development
Member Avatar

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/ …

Web Development
Member Avatar

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 …

Web Development
Member Avatar

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 …

Topic by ehpratah

Got it! Line 45 is the one causing the problem..i just remove that line and everything working fine.

Web Development
Member Avatar

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 …

Topic by ehpratah

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 …
Web Development
Member Avatar

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 …

Topic by ehpratah

also i'll post again the sql dump here without the contact info when i reach home. sorry im on mobile

Web Development
Member Avatar

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 …

Topic by ehpratah

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 …

Web Development
Member Avatar

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 …

Topic by ehpratah

Anybody have an idea whats wrong im doing?

Web Development
Member Avatar

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 …

Topic by ehpratah

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 …
Web Development
Member Avatar

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 …

Topic by ehpratah

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 …