Questions tagged as 'mysql'

Tagged questions
0
answers

Problem creating a Stored Procedure in Mysql

I explain my problem, I am following a course of C # and SQL Server , but I do not occupy the same database manager but MYSQL in a part of a video explains about user permissions. I show you that part of the code. DELIMITER $$ CREATE PROC...
asked by 17.04.2018 / 20:20
2
answers

ORDER BY RAND in records

Does anyone know how to use the order by rand? to show random records of a table. Could you show me any example? SELECT nombre, precio FROM productos ORDER BY RAND() LIMIT 0,10     
asked by 18.04.2018 / 01:19
2
answers

Detect the value change of a php variable

I have a question: How is it possible to know when a variable in php changes value in a while cycle? I have a query that I make to a BD in which it brings me several data, among them it brings me the number of days elapsed. Then I throw...
asked by 28.02.2018 / 16:45
1
answer

Subquery - Group By - SQLite

Ok, I have two Queries, the first one I ask for the names of the clients and I order them alphabetically: SELECT Firstname, Lastname FROM customers ORDER BY Firstname In the second I request the total of purchases: Select Custom...
asked by 13.02.2018 / 05:14
0
answers

Update with Check Box with Fatal Error - PHP + MySQL

Hello, I am trying to update in the "operator" field for each request in which the check box is pressed. With this code I get this error (Fatal error: Call to a member function update () on null). Can someone help me? global $wpdb; $solicitud...
asked by 15.02.2018 / 01:16
1
answer

Problem to update several records with php and mysql combobox

Hello, this is the first time that I have programmed in php and I have a problem that I have not been able to solve. I can not get the data in a mysql column updated using a combobox with 2 elements. The page is like this : and this i...
asked by 15.02.2018 / 15:48
1
answer

Generate a report in PDF in PHP AND MYSQL

Good evening I make a report in PDF with PHP and MYSQL of what my table of my BD contains are: * (main table) "worker" with the attributes control_id, name, ap_parter, ap_maternal, NSS, CURP, RFC and with the foreign keys id_puesto, id_area,...
asked by 15.02.2018 / 06:11
0
answers

How to display the coordinates saved in the Mysql database in Google Maps? [closed]

How can I show the coordinates I have stored in the Mysql database and display them in Google maps using PHP? or how should it be done?     
asked by 22.02.2018 / 20:59
1
answer

How to show the data of a table in codelgniter?

When loading my data in my view, it does not seem like anything to me I leave you my driver public function ver(){ $data = array( 'enlaces' => $this->Usuario_model->verCita() ); $this->load->view('login_vi...
asked by 05.02.2018 / 19:49
2
answers

Run a local PHP MySQL Web application

It happens that I have made a system in PHP, this system works through queries to a DB created in MySQL. I have used WAMP for the installation of the server that provides me the functionalities that I require, PHP, MySQL, Apache. The doubt ar...
asked by 22.03.2018 / 00:59