Questions tagged as 'mysql'

Tagged questions
3
answers

SQL query in PHP with LIKE

Good morning, I'm doing the following query in PHP, do not send me any errors but do not throw anything at me as results. $sql = $conn->prepare("SELECT Nombre, Campania, Puesto, Turno FROM usuarios INNER JOIN campania ON usuarios.IdCamp...
asked by 25.05.2017 / 18:06
1
answer

The Default / expression field in MySQL (Worbench) What is it for?

I'm doing a database in MySQL with MySQL Worbench and I wonder how you can help me in my database. What is the default / expression field used for when creating a table?     
asked by 25.05.2017 / 19:05
1
answer

Add radio input to a table horizontally

Good afternoon, I have a table with some static and other dynamic data that it retrieves from the BDD as shown below: Now what I need is to add some radio-type input but in a horizontal way because if I add them vertically I would only all...
asked by 25.05.2017 / 21:26
1
answer

I have problems with a query in mysql help!

Hi, I'm doing a library system programmed in php and within that system I have a search engine to view the books. The program already does a basic search and shows results but some fields no longer correspond, the problem or rather the question...
asked by 17.03.2017 / 03:51
1
answer

mysql nested queries

I have 2 tables of agreements and one of associates, I consult the agreements because an agreement can have several associates I get all the members' nit and then I need to obtain all the names and surnames of the associates from the associated...
asked by 06.03.2017 / 19:39
1
answer

fill fields of a form with data from a mysql bd when selecting a select

the idea is that by clicking on any option of a select depending on this I fill in the fields of my form I am working with php, mysql: this is my select <select name="ruta" id="ruta" class="form-control" onchange="showService(this.value)"&g...
asked by 06.03.2017 / 20:01
2
answers

Problem with INNER JOIN

I am using INNER JOIN to list the demos and its descripcion , but now I need to add to this info the tags which are saved in a table tags with a name and a demo_id that would be the way to associat...
asked by 21.03.2017 / 21:02
1
answer

How to receive codeigniter variables without having to load the view?

To edit the data of a person I have a button which when pressed takes that id and sends it not by ajax but directly to the controller with the id to make the validation and bring the data ... What I want is for that data to show me in a modal...
asked by 07.03.2017 / 22:31
1
answer

Error to know who is connected as FaceBook

Hello friends I have a very strange error with my code to see who is connected but this works when you want there is one that comes online and there are others offline and the weird thing is that there are others that do not even leave anything...
asked by 07.03.2017 / 01:48
1
answer

Increase correlative with an insert

I have a table with this structure: CREATE TABLE IF NOT EXISTS 'prueba_insert' ( 'id' int(11) NOT NULL, 'asiento' int(11) NOT NULL, 'correlativo' int(11) NOT NULL, 'glosa' varchar(30) NOT NULL, PRIMARY KEY ('id') ) ENGINE=InnoDB DEFA...
asked by 22.02.2017 / 15:56