mysql query for angular js if u can solved?

109
July 12, 2018, at 05:50 AM

Any one please write query if u can? I have one table :-x_table

user | status |ticket_id |work | A | Comp. |232 | housing | A | N.Comp.| 23 | cleaning| B | Comp. | 21 | housing | B | N.Comp | 43 | cleaning|

I have to show following table user |total ticket |Comp.|Not Complete|work| A | 1 | 1 | 0 | housing| A | 1 | 0 | 1 |cleaning for same B also

Rent Charter Buses Company
READ ALSO
How can I create a “Compoite Model” and migrate to a “Composite Table”

How can I create a “Compoite Model” and migrate to a “Composite Table”

I'm currently learning the Composite Design Pattern and its use in Laravel and I can't figure a few things

95
How to use trim() for persian characters

How to use trim() for persian characters

Any help would be awesome thanks

145
mb_strtoupper not recognizing quotes

mb_strtoupper not recognizing quotes

I'm having problems with mb_strtoupperI need it to capitalize a text that is in a newsletter generated in PHP (so I cant just capitalize it with css, and is stuck using a PHP function that will capitalize the text)

119
Redirect to another page using PHP

Redirect to another page using PHP

I'm trying to check weather or not a user is logged in, and if not redirect the user to the login page

204