Posts by João Simões • 98 points
7 posts
-
0
votes0
answers73
viewsQ: Error in Mysql sub-query in Workbench
Good morning! My code SQL is making the following mistake: Error Code: 1242. Subquery Returns more than 1 Row 0,000 sec The code is as follows:: SELECT DATE_FORMAT(FROM_UNIXTIME(data), '%Y') AS ano,…
-
0
votes2
answers78
viewsA: Comparison of php dates
Good morning Igor! This will only work if you have BD! This program does not work on PDO (Object Oriented PHP)! NOTE: At the end I put a if that will compare the two values. There are several ways…
-
0
votes1
answer106
viewsQ: How to style text from a Google Charts chart
Good morning! I have a question about using the Google Charts. I wonder how do I put style in the text. I know what can be done in the title using titleTextStyle, but I don’t know how to do for the…
google-chartsasked João Simões 98 -
4
votes2
answers764
viewsA: SELECT from the last 365 days (12 months) in sql
Thank you very much to all those who are willing to help me, but fortunately I have already solved. The code to solve is here: SELECT COUNT(id) AS id, DATE_FORMAT(create_time, '%m-%Y') AS data_mes…
sqlanswered João Simões 98 -
3
votes2
answers764
viewsQ: SELECT from the last 365 days (12 months) in sql
Good morning! I’m having some difficulty making one SELECT selecting data from the last 365 days (12 months). What I want you to show is: in the last 12 months you have to show (per month) a number…
sqlasked João Simões 98 -
0
votes2
answers64
viewsA: I’m getting two errors when I try to search by name in a product table
Good afternoon! First of all be careful with the names you give! In your PHP code there are two or more $sql repeated.. may be giving error there. Anyway you also have a syntax error... $result =…
-
0
votes1
answer79
viewsQ: Date problem in PHP (SELECT)
Good afternoon! I have a PHP question! I have a code to show all the fields of a table where the date is 2018. $sql_manutencao = 'SELECT * FROM manutencao WHERE data_trabalho LIKE "2018%" AND…
sqlasked João Simões 98