Questions tagged as 'mysql'

Tagged questions
1
answer

radio buton and textarea in a dynamic questionnaire

I am creating a dynamic questionnaire with MYSQL and PHP 7. In a page I create my questions and my questionnaire and I keep them in MYSQL and in another page I show them making a call to the database to bring me the questions. only that I hav...
asked by 08.02.2018 / 14:30
2
answers

I can not find the right sql query

I have a question in which I need to know the number of updates since the last time a user enters a thread . Each time a user enters a thread, the following query is executed: INSERT INTO visita_post ('postId', 'nick', 'fecha_ultimo_acceso...
asked by 08.02.2018 / 14:45
1
answer

Help with this query

I am bringing information from several tables for a general information report based on the date but the problem is that I duplicate information SELECT insumos.fecha,insumos.producto,insumos.cantidad, mano_obra.nombre,mano_obra.pago,m...
asked by 01.02.2018 / 00:01
0
answers

Error trying to display data from 2 tables using php and mysql

I'm having an error trying to show data from two tables. Error: Warning: Invalid argument supplied for foreach () in C: \ xampp \ htdocs \ Frank \ principal.php on line 45 <?php $consulta= "SELECT CONCAT(nombre,' ',a...
asked by 01.02.2018 / 01:31
1
answer

Get maximum values of a COUNT in mysql

good afternoon You will see, the query is this - > 4. Name of the song that has sold the most units. The issue is that I'm trying to get the maximum values of a count in a subquery, so that SELECT Track.Name, COUNT(invoiceline.Quantit...
asked by 03.02.2018 / 18:26
0
answers

Join four tables using Join

In my DB I have a scenario with four tables and I make this query based on them: SELECT T1.'demo_eleccion_ideleccion' AS 'Ideleccion', T1.'idcandidatos' AS 'Idcandidatos', T1.'nombre' AS 'Candidatos', T1.'numero' AS...
asked by 03.02.2018 / 13:50
0
answers

Wordpress: $ authors_posts does not return the author

I try to do a var_dump to verify if the author brings me the name, but I get null o.o This is the code: <?php $authors_posts = get_posts( array( 'author' => 19, 'numberposts' => 1, 'orderby' => 'date' ) ); var_dum...
asked by 03.02.2018 / 07:30
0
answers

Error in Apache

I try to start Mysql to connect it with wordpress but I get this error in the apache and I change the ports and nothing works for me any solution?     
asked by 03.02.2018 / 03:50
0
answers

PHP - I do not work fetch_all (MYSQLI_ASSOC)

Fatal error: Uncaught Error: Call to undefined method mysqli_result :: fetch_all () in C: \ MAMP \ htdocs \ gdlwebcamp \ index.php: 76 Stack trace: # 0 {main} thrown in C: \ MAMP \ htdocs \ gdlwebcamp \ index.php on line 76   getMessage ();   ...
asked by 29.04.2018 / 02:17
0
answers

Problem with IntelliJ and Databases. SSH_MSG_DISCONNEC

I have a connection to a database through an SSH tunnel. Every time I close the IntelliJ and reopen it and try to access the database, I get the following error: SSH_MSG_DISCONNECT: 2 Too many authentication failures However, I can use SSH...
asked by 28.04.2018 / 19:38