Click here to Skip to main content
15,440,179 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
Questionscreen with error in displaying the data, sql code does not work Pin
mynameyugioh21-Aug-20 13:38
Membermynameyugioh21-Aug-20 13:38 
QuestionAdding uploaded file in email response contact form mail.php Pin
DixieReid21-Jul-20 15:18
MemberDixieReid21-Jul-20 15:18 
AnswerRe: Adding uploaded file in email response contact form mail.php Pin
Richard Deeming21-Jul-20 23:22
mveRichard Deeming21-Jul-20 23:22 
GeneralRe: Adding uploaded file in email response contact form mail.php Pin
DixieReid22-Jul-20 0:09
MemberDixieReid22-Jul-20 0:09 
QuestionHow can I submit with 1 button and 1 form with 2 actions? Pin
amitb221-Jul-20 0:08
Memberamitb221-Jul-20 0:08 
Rant[REPOST] How can I submit with 1 button and 1 form with 2 actions? Pin
Richard Deeming21-Jul-20 1:05
mveRichard Deeming21-Jul-20 1:05 
GeneralRe: [REPOST] How can I submit with 1 button and 1 form with 2 actions? Pin
Richard MacCutchan21-Jul-20 1:17
mveRichard MacCutchan21-Jul-20 1:17 
QuestionSubtraction of sum of 2 different table colums Pin
Mick Chambers17-Jun-20 21:58
MemberMick Chambers17-Jun-20 21:58 
Hi everyone.

I am a complete novice and need help on some coding

I have a database with 2 tables.

one table is called income and in this table i have a column called IAMOUNT (this represents income amount)

the other table is called expense and in this table i have a column called EAMOUNT (this represents expense amount)

I want to subtract the expense from income to show a profit if any.

For example if IAMOUNT was lets say 100 and EAMOUNT was lets say 50 then profit would be 50.

However if IAMOUNT was lets say 100 and EAMOUNT was lets say 110 then profit would be -10

I need help with the code and how do i echo the result.

I have tried copying code from other questions on this but i just cant understand the coding to adapt it to my use.

help would be much appreciated.

Thanks
AnswerRe: Subtraction of sum of 2 different table colums Pin
Richard MacCutchan17-Jun-20 23:43
mveRichard MacCutchan17-Jun-20 23:43 
GeneralRe: Subtraction of sum of 2 different table colums Pin
Mick Chambers18-Jun-20 2:11
MemberMick Chambers18-Jun-20 2:11 
GeneralRe: Subtraction of sum of 2 different table colums Pin
Richard MacCutchan18-Jun-20 4:39
mveRichard MacCutchan18-Jun-20 4:39 
GeneralRe: Subtraction of sum of 2 different table colums Pin
Mick Chambers18-Jun-20 2:13
MemberMick Chambers18-Jun-20 2:13 
GeneralRe: Subtraction of sum of 2 different table colums Pin
Richard MacCutchan18-Jun-20 4:40
mveRichard MacCutchan18-Jun-20 4:40 
QuestionHow to handle response after PayPal subscription approval Pin
Petar Vasilev1-May-20 10:27
MemberPetar Vasilev1-May-20 10:27 
Questionhow to add additional in php query or jquery Pin
captan389926-Apr-20 21:57
Membercaptan389926-Apr-20 21:57 
AnswerRe: how to add additional in php query or jquery Pin
Richard MacCutchan26-Apr-20 22:35
mveRichard MacCutchan26-Apr-20 22:35 
AnswerRe: how to add additional in php query or jquery Pin
Richard Deeming27-Apr-20 0:33
mveRichard Deeming27-Apr-20 0:33 
Questionsocket_send not working without break or exit Pin
Member 147929365-Apr-20 2:04
MemberMember 147929365-Apr-20 2:04 
QuestionHow to share session cookies from a PHP application with my WordPress website, hosted on the same server and the same domain? Pin
mplusplus29-Dec-19 17:50
Membermplusplus29-Dec-19 17:50 
AnswerRe: How to share session cookies from a PHP application with my WordPress website, hosted on the same server and the same domain? Pin
who8mypnuts31-Dec-19 16:28
Memberwho8mypnuts31-Dec-19 16:28 
QuestionSubmit to view hyperlink using PHP? Pin
Member 829590119-Jul-19 10:11
MemberMember 829590119-Jul-19 10:11 
Questionphp + validation ajax + ISSET() Pin
nelsonpaixaopinto16-May-19 12:51
Membernelsonpaixaopinto16-May-19 12:51 
QuestionFailover Architecture (Apache/TOMCAT) Pin
Member 143600218-May-19 3:21
MemberMember 143600218-May-19 3:21 
Questionwhat is the error:mysqli_query() expects parameter 1 to be mysqli, null given in Pin
Amir karim30-Apr-19 7:29
MemberAmir karim30-Apr-19 7:29 
AnswerRe: what is the error:mysqli_query() expects parameter 1 to be mysqli, null given in Pin
Richard MacCutchan30-Apr-19 21:39
mveRichard MacCutchan30-Apr-19 21:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.