Questions tagged as 'mysql'

Tagged questions
2
answers

default cursor php field

I have this form in php connected to an information in mysql    $ contents [] = array ('text' = > ' description '.   tep_draw_input_field ('description', $ mInfo- > description));   $ contents [] = array ('text' = > ' Quantity '.   ...
asked by 14.04.2018 / 10:28
2
answers

consultation with use of Case in Mysql?

select case when precio<2000 then (select concat_ws(" ","Tarjetas madres menores a 2000 pesos", (select * from componente inner join tarjetaMadre on componente.id_componente=tarjetaMadre.id_componente)) els...
asked by 11.04.2018 / 12:46
1
answer

My PHP tags do not work

I'm programming in PHP a function to connect to the mysql DB, but I think the system is not recognizing the php lines. Because I've tried even with a simple "helloMundo.php" and does not recognize it. Specify that I have the tags activated, I at...
asked by 28.04.2018 / 17:18
1
answer

Selection of two fields from different tables, all in one

I have two tables in a BD. One is the table of vehiculo and another one of vehiculo_especial . vehiculo --------- pk_vehiculo modelo matricula kms_actuales prox_itv prox_revision ----------- ------- -------...
asked by 27.04.2018 / 16:25
2
answers

MySql order clause ORDER BY

I have to make a series of selects to get information, as we always do. The thing is that it would be much easier to sort them using first ORDER BY after UNION . I leave the consultations here select CAST(COUNT(*) AS CHAR(10...
asked by 26.04.2018 / 14:01
1
answer

how do I bring records with select?

I have this code connected to a database with a I want to bring me the data related to that registry but it does not work for me I'm using ajax. getuser.php <html> <head> <script> function showUser(str) {...
asked by 03.04.2018 / 04:24
1
answer

iTextSharp does not matter DataGridView to MySQL and C # pdf

I have a Form that generates a DataGridView in which I show fields of a table. The problem I have is that you export the pdf to me in the following way: I do not know what's happening. Here is my code that generates the .pdf: priva...
asked by 23.04.2018 / 01:47
1
answer

class Mysqli_Database.php does not return results in a prepared query

I am running the following code to make a query: public static function myfuncion(){ $conm = new Database(); $sql = "select 'user_nombre' from '".self::$tablename."' where 'user_nick' = ?;"; $conm->prepare(...
asked by 01.04.2018 / 20:48
1
answer

Sort data in a selected PHP

I have a problem with a list in php . It turns out that when I do the SELECT in MySQL I print the list as is, but when I call that SELECT to put it in a list I bring it ordered alphabetically. That's the order in...
asked by 23.04.2018 / 18:21
1
answer

Failed to execute statement in SQL Server 2008 [duplicate]

I need to run this MYSQL statement in SQLServer CREATE TABLE venta ( idVenta INTEGER PRIMARY KEY, Fecha DATE NOT NULL, Cliente_Cedula INTEGER NOT NULL, producto_idProducto INTEGER NOT NULL, empleado_Cedula INTEGER NOT NULL, can...
asked by 02.03.2018 / 18:14