Questions tagged as 'mysql'

Tagged questions
2
answers

Relation between 3 tables and search result from last week mysql

I have three tables, tbl_recursos , tbl_categorias , and tbl_categoria_recurso . The tbl_recursos consists of the listing of resources posted by the user. tbl_categorias are the categories that a resource can hav...
asked by 29.07.2014 / 16:11
1
answer

How can I update a blob mysql field using php

if(isset($_POST['submit_edit'])) { if (empty($_POST['imagem'])){ $titulo = $_POST['titulo']; $texto = $_POST['texto']; $query ="U...
asked by 02.08.2014 / 12:41
0
answers

Plugin javascript or jquery estrelinhas [closed]

Note:    I do not know if you can ask this question here, if not! Please disregard / delete. Does anyone know of a plugin that I can do this screen (the rating): WherethisratingI'mtryingtodo,Ifoundthis plugin and I'm reading his doc...
asked by 04.09.2014 / 21:41
9
answers

How to prevent SQL injection in my PHP code?

I developed a page in PHP for internal use of the company I work with and only very few people use it. You can use this page to do some queries, insertions, changes and deletions of a table in a MySQL database, however I believe that my PHP code...
asked by 03.02.2014 / 13:37
0
answers

How to create tag system similar to Blogger? [closed]

Sirs, I'm trying to add a Blogger-like Tags system to my CMS (in PHP / MySQL). In the news registration page, I would like the administrator to add information separated by commas in the "tags" field. In this way, when registering the i...
asked by 02.09.2014 / 02:54
1
answer

How to pass two tables to one and update the codes

Some time ago I created two tables, under different names, (for lack of experience), today I noticed that they had exactly the same fields. So I decided to put them together. But I need to do this without losing data. What command can I make...
asked by 07.05.2014 / 16:29
3
answers

Select bringing maximum columns with something written - MYSQL

I have the following structure in a MySql table: link I need to make a select that brings me the maximum number of posts that have a record, for example, at reference 269, bring me to station 4, and at reference 258, bring me up to stat...
asked by 28.06.2018 / 13:50
1
answer

prime numbers from 0 to 10 in mysql

Good afternoon, I'm having difficulty with this MySQL question: Show the animals' names and breed code. Just show the animals that contain a prime number from 0 to 10. I tried the following code: SELECT nome, raca from animais where (...
asked by 07.08.2018 / 19:43
1
answer

SQL Error: Can not reopen table

I have a problem when performing an SQL using a temporary table . I need to bring the data da ultima alteração into which the opportunity has changed. However, this date comes from several tables for the same opportunity. An opportuni...
asked by 14.05.2018 / 23:09
2
answers

How to fill a Select dropdown based on the value of another select, the data comes from the same table in db

I have a database where information is stored from the year. In the site I have 2 Selects, one for year and one for the files of that year, I currently do this with JS but I wanted to move to mysql, hence I wanted to know how to do for example i...
asked by 15.06.2018 / 15:00