I am trying to make a query to validate if a specific appointment already exists, since in the same period of time no other appointment should be generated. For this I consult the date of the appointment, the initial hour of the appointment and...
I want to show a certain number of "products" on the screen, I create a series of bootstrap letters to store the information there.
I generate my connection (I clarify that the connection is perfect):
<?php
$conexion = mysqli_connect("lo...
I need to count the rows that result in this statement (it works correctly and I know it returns a single value):
SELECT comp.descripcion
FROM componente AS comp, pieza AS pza, pieza_equipo AS pzaequip, equipos AS equip
WHERE comp.codigo = p...
I'm doing a function to bring some courses for that I have a post type where I charge the courses and a taxonomy of marks that I assign to which course they belong to show this I have a section that is a filtering where I have to tell you which...
Hi, I'm having a problem when updating a field in my database, it does not throw me any errors, it just does not update the field in the database.
I have the Product Class and a constructor that is as follows:
public Producto(String strNomb...
I have an error in my code:
$conexion = connect::con();
$compro_cod = "SELECT * FROM producte WHERE codprod = '$codprod'";
$existe = mysql_query($conexion,$compro_cod);
if (mysql_num_rows($existe) > 0){
print_r('Error: Ya existe ese...
The fact is that I want two specific fields of different tables and with different names to have the same value continuously, without having to do querys, that is, as if one were the image of the other. Could I do it?
I have two related tables ( Computers and Companies ).
Computers (the company column refers to the companies table.)
Companies
Using MYSQL, I want you to show me the result of how many computers there are in those compan...
I have this code:
$getAlumno = mysqli_query($con,"SELECT * FROM alumnos INNER JOIN modulos ON alumnos.nivel=modulos.ID WHERE alumnos.ID='$login'") or die ('error al obtener datos de alumno');
$row = mysqli_fetch_array($getAlumno,MYSQLI_ASS...