Questions tagged as 'mysql'

Tagged questions
1
answer

Help with this page in php [closed]

I made a web page in php. But I want to add some things like input and type in each column to search in each table the corresponding field The corresponding table in mysql CREATE TABLE IF NOT EXISTS 'coffee' ( 'id' int(11) NOT NULL AUTO_INCR...
asked by 10.09.2016 / 11:42
1
answer

Select rows with a date lower than another MySQL

The tables that are available in the exercise are: Master master_id |INT ----> PRIMARY KEY name | VARCHAR ----> ALTERNATIVE KEY curriculum_rev | DATE Subject subject_id | VARCHAR -----> PRIMARY KEY name | VARCHAR language...
asked by 27.12.2018 / 18:04
1
answer

PHP date handling

I have this problem and I do not know how to translate it into PHP code: Know how many times a person has attended in a month to a place. But the month begins the day that person came and the month ends 30 days later. That is, if a person comes...
asked by 30.11.2018 / 23:08
1
answer

Select a record randomly in MySQL with PHP

How can I randomly select a record in a database that meets a condition (that is, it is also possible to use the WHILE). mysql_query("SELECT * FROM mitabla WHERE cat=4 ORDER BY RAND() LIMIT 1"); That example would be fine?     
asked by 14.11.2018 / 16:53
2
answers

Sort records from one table from others in another MYSQL table [closed]

My problem is as follows. I need a query to order a list of articles for the amount of comments that each one has. I have a Table Articulo(id,titulo,contenido) and another Comentario(id,id_articulo,comentario,id_usuario)...
asked by 21.12.2018 / 19:19
2
answers

How to put mysql data in a html page [closed]

I'm making a website, but I do not remember how to do this procedure ... an example is: Name: (empty field) Last name: (empty field) and passing data from mysql would look like this: Name: Juan Surnames: Perez Godinez.     
asked by 14.03.2018 / 05:26
1
answer

Bot Telegram with Python connected to MySQL [closed]

Hello, I have started a project with a bot for telegram which should be developed with Python and should make queries to MySQL but the vdd I am not aware of the subject but I would like to know if there is a way to do it? I have knowledge in...
asked by 13.07.2017 / 22:53
1
answer

Pass PHP variable between manners that are not on the same page

I have an error that tells me $ data undefined I know why it happens but I want to pass it to a button that has a modal store them as a string like this: I have to create a separate individual php and pick up the data of my mod...
asked by 14.12.2018 / 14:28
1
answer

Find coordinates in X Km round

I need help with this SELECT : SELECT CONCAT( '[', GROUP_CONCAT(JSON_OBJECT('id', h.hotel_id , 'nom', h.nom, 'estrelles', h.categoria, 'puntuacio', h.puntacio, 'tipus', h.tipus, 'descripcio', h.descripcio, 'adreca', h.adreca, 'lat', h.latitu...
asked by 16.03.2018 / 08:58
1
answer

I need to enter a new column in mysql but it does not leave me [closed]

I was entering columns normail mind but when creating a date type I get the following error SQL query: ALTER TABLE 'asignacion_tablet' ADD 'inicio' DATE NOT NULL AFTER 'Celular';MySQL said: Documentation...
asked by 20.11.2017 / 16:17