Questions tagged as 'mysql'

Tagged questions
1
answer

Warring: mysqli_query () expects parameter 2 to be string, object given in

I leave the code so you can help me: <?php session_start(); include ('Connections/conexion2.php'); $arreglo=$_SESSION['carrito']; $numeroventa=0; $re=mysqli_query($con, "SELECT * from compras order by numeroventa DESC limit 1") o...
asked by 11.06.2018 / 02:14
1
answer

Save user values in MySQL

I have a question, I am making a small web page, which will have a login, each user will have different permissions to access different pages and certain functions, the problem is that I can not find a way to store this information , I do not kn...
asked by 05.09.2018 / 16:14
1
answer

Extract a column of MSQL names and save it in a PHP array

What I want is to extract the names from the database and save them in an array and then display them according to the order as I saved them in the array I want to save it in the $ student [] array <?php $...
asked by 07.09.2018 / 18:13
1
answer

Save the annual total of all income

Hi guys I will be brief and precise with this question, I want to save in my mysql table ( total_anual ) that contains the following cells: year, anual; and guadar the annual total of my table ( factura ) contains the f...
asked by 15.09.2018 / 18:57
1
answer

How to have several values in a sql query [closed]

I have a database and I make a query that only shows several data and others do not. Example. That from a table to take the models of the cars, but that they are not certain marks, How would the query be?     
asked by 16.08.2017 / 02:27
1
answer

'MSDASQL' does not support the required transaction interface

I have created a linked server between a Microsoft SQL Server 2000 and MariaDB Server 10.1.17. For this I used the ODBC connector version 5.1 downloaded from the MySQL website. The problem that arises is when doing distributed transactions...
asked by 21.09.2017 / 11:47
1
answer

Doubt to hide some fields in ireport?

How about. I am new with the use of ireport, I have created the report with the query and everything works fine but I do not think that when the total sum of the row of "states" is equal to 0, do not print these fields. (In a row I have 3 fields...
asked by 21.08.2017 / 20:39
2
answers

It does not work for me DataTable

Good day, I have a project in php and I have a table that brings data from the database and I have the datatable link, but I get the table with all the records down and do not store them by page. If it makes me responsive, but it's because of bo...
asked by 24.01.2018 / 02:09
1
answer

I update all pivot records

In Laravel 5.4 I'm trying to save the contents of an N: M relationship in a pivot, the problem I have is that it updates all the records that are related to that id, it's like I did an update with the where of the id of the student. The code:...
asked by 25.08.2017 / 15:17
1
answer

SQL Script error - Do not create all the complete tables

Good afternoon! I hope you can help me. I am creating a BD for a project. The logical design I did with MySql Workbench and generate the Sql Script to create the database. The issue is that when executing the Script in...
asked by 24.08.2017 / 13:33