mysql - PHP : How to get Sum of values in column in a variable -


i'm trying sum of salary column table. need echo total salary. tried,

select sum(salarycol) my_table;

how can query result variable in php?

select sum(salarycol) total_salary my_table;

Comments

Post a Comment

Popular posts from this blog

4x4 Matrix in Python -

im trying code 4x4 matrix in python random integers 1-4. thats easy enough problem want each row , each column 1 time uses of each digit 1-4 example 1 2 3 4 2 3 4 1 3 4 1 2 4 1 2 3 my code 33% of time in loop there happens somthing this 2 1 4 3 3 4 2 1 1 3 x <-------- because of programm cant contiune , end in infinity loop helb how can out? code below """ programm playing game skyline """ random import randrange row1 = [] row2 = [] row3 = [] row4 = [] allrows = [row1, row2, row3, row4] column1 = [] column2 = [] column3 = [] column4 = [] allcolumns = [column1, column2, column3, column4] def board(): in range(4): j = 0 while len(allrows[i]) != 4: x = randrange(1,5) print(i, j) if x not in allrows[i] , x not in allcolumns[j]: allrows[i].append(x) allcolumns[j].append(x) j += 1 else: continue boa...
Read more

python - PyInstaller UAC not working in onefile mode -

hello everybody. i have small python project , want make single executable file . using... windows 7 python 3.4 pyinstaller 3.2.1 my pyinstaller command is, pyinstaller -y -w -f -n output_file_name --uac-admin --clean source_file.py this command works properly. single output file not ask admin rights when executed. , there's no shield mark on executable file icon. when remove -f option (equivalent --onefile), output executable file has shield mark on icon , ask me admin rights. not want. want single executable file. i found manifest file (output_file_name.exe.manifest) in dist\output_file_name folder. did... pyinstaller -y -w -f -n output_file_name --manifest output_file_name.exe.manifest --uac-admin --clean source_file.py but command doesn't work. single executable file still not ask admin rights. i have removed pyinstaller , installed recent development version. pip install git+https://github.com/pyinstaller/pyinstaller.git@develop but result...
Read more

javascript - Building and updating array objects -

i'm working on simple registration system displays number of seats available in particular workshop. it's built in google apps script runs javascript syntax. i build array of class objects user when log in. 1 of object keys seats , shows available number of spots left in workshop. that, compare master list of classes max number of registrants current registration list. class object [{ date: 4/10/2017, title: "workshop 1", desc: "a string description 1", seats: "" }] google sheets table | date | title | description | seats | | |-----------|------------|----------------------------|-------|---| | 4/10/2017 | workshop 1 | string description 1 | 20 | | | 5/10/2017 | workshop 2 | string description 2 | 25 | | current registrations | user | class0 | class1 | |-------|-----------|-----------| | user1 | 4/10/2017 | | | user2 | 4/10/2017 | 5/10/2017 | | | | ...
Read more