Questions tagged as 'mysql'

Tagged questions
1
answer

Run several prepared queries

I have a query in which in the while of that query I make another subquery but it does not bring anything. Could you see what's wrong with the code that does not bring anything? It does not actually go through the first while. function...
asked by 04.05.2017 / 06:13
1
answer

Fill select with data from a table

I am trying to fill select with the data of a table called municipios , but I have not gotten it to work, the code is as follows: <!doctype html> <html lang="es"> <body> <select name="comboseleccion"> <...
asked by 05.05.2017 / 22:22
1
answer

What is the error in this sprintf ()?

$sql = sprintf("INSERT INTO users (firstname, lastname, email, phone, state, dob, rules, pepsico_news) VALUES (%s, %s, %s, %s, %s, %s, %u, %s)", $fname, $lname, $email, $phone, $state, $dob, $rules, $pepsico_news); You have an error in your SQ...
asked by 25.04.2017 / 16:22
1
answer

does anyone know how I can put a date as the name of a column in phpmyadmin?

It turns out that I have a php with data and one of these is a date and I want to put it as the name of a column but I get an error, they know how I can do it so that I do not get that error, this is the php <?php require('../../conexion.ph...
asked by 18.04.2017 / 02:10
1
answer

Drop down list with PDO [closed]

Good morning, I'm trying to get the data in a combo and I do not know if something fails me, you should show me the fixed options. $pdo = new PDO('mysql:host=localhost;dbname=prueba', 'root', ''); $sql = "SELECT acro_subcategoria FROM tipodocu...
asked by 18.04.2017 / 09:05
1
answer

Update a graph without refreshing the page

Very good people, I have a graph connected to my database, it shows me the values on the Y axis, and the time on the X axis, so far all excellent, this is my graph: How to make it an online graphic, I mean. And update automatically each...
asked by 18.04.2017 / 16:32
2
answers

How to show the results of a query in mysql with php in an html table?

What I need is that when executing a query to the database, this result is displayed in a table and in each column what corresponds, is done with php and mysql what happened to them what I was doing $query = 'SELECT DISTINCT per.PERSC_Nombr...
asked by 17.04.2017 / 19:56
1
answer

sql query in mysql shows repeated records

I have a query in which I want to get the name of a course when a field is different the problem is that it shows me repeated records know what the problem could be. the query should only show courses that you do not have assigned tables...
asked by 16.04.2017 / 20:11
1
answer

Data comparison error in database

Trying logearme with username and password from your own database, does not make the correct comparison in if and skips to condition else . Code import mysql.connector import sys from Tkinter import * dato={ "user":"ro...
asked by 17.04.2017 / 01:30
1
answer

Query with mysql date

I have a table with a field of type TIMESTAMP , I want to perform a grouping query for the same day record, without taking into account the time. Is there a function of MYSQL for that type of data that does this?     
asked by 22.04.2017 / 21:06