Questions tagged as 'mysql'

Tagged questions
3
answers

I would like to order an array that I create from mysqli_fetch_array

Greetings friends, I would like to know how to order a list that you create from a mysqli_fetch_array . Apart from this code I have a search engine, what I want is that the results of the search appear in a specific row, for example cod...
asked by 23.06.2016 / 00:29
3
answers

Get several data in a single mysql query

I have a mysql database of the index of a course (id,tipo,titulo,completado) I keep the different types that make up the index (classes, exercises and exams). I need to know how many exercises, classes and exams the course has to do so: S...
asked by 21.04.2017 / 20:40
1
answer

Error using SUM in MySQL and displaying by groups

The problem is the following: I have a query which takes all the information of a teacher including with his two salaries, which I have to add and show them by calendar, previously in another question they answered that I could make the sum by g...
asked by 20.05.2017 / 02:23
1
answer

I try to get this query different

I need to draw from these three tables: user: user_type restaurant: all those restaurants that do not belong or do not have a type_user 1 (owner), that is to say in this case I would need to take out restaurant wine...
asked by 21.05.2017 / 18:26
2
answers

Login MySQL, PHP and AJAX

I am developing an application with Phonegap . I would like that when I log in, I will check if it exists in the database. In case you have to save the email address ( email ) in localStorage . HTML Code: <div class="login...
asked by 15.05.2017 / 12:23
1
answer

Normalize database up to the Third Normal Form

I am designing a database for the Film industry (personal exercise). Each film was made by a company. A company produces one or more movies. Each film has one or more genres (action, terror, etc ...) Each film has one or more actors....
asked by 09.11.2017 / 20:14
1
answer

Show data with result in zero mysql

I have a database that makes queries to know the amounts of detailed information of each table, which are sorted through a "country table". When you perform the query, only the information that contains data appears, for example: in the count...
asked by 08.11.2017 / 14:46
1
answer

Create method show () in Laravel

I am working on a library control system, when making an individual view of an element of the database I use the show method of my LibroController in the following way: public function show($id) { $libros = Libro::find($id);...
asked by 04.02.2017 / 00:50
1
answer

How to show the data of a database in a table in html and php

I'm new to php and html and I want to show the data in a custom table by bootstrap, this is my code <?php // Conectando, seleccionando la base de datos $link = mysql_connect('localhost', 'root', 'usbw') or die('No se pudo...
asked by 14.06.2017 / 02:57
1
answer

How to solve this exercise in MySQL

Can anyone help me with this exercise ?: Show for each contract the total amount of commissions, amount payable, amount paid. The tables that are named in it are: Contracts: dni, cuit, nro_contract, cod_cargo, salary, percentage_comi...
asked by 14.12.2016 / 20:36