Questions tagged as 'mysql'

Tagged questions
2
answers

Show a default value in a listbox obtained from a MYSQL database

I have the following table that shows a list of data inserted in it: Career Table: To show them in the form I use the following function: function bd_carrera_opciones() { $sql = "SELECT carr_id,carr FROM carrera ORDER BY carr ASC";...
asked by 01.12.2016 / 16:25
1
answer

What is the SQL statement to insert data in my Database in MySQL in Java?

In my program using Java in Eclipse and MySQL, I have the following data: Call number (int): callcenter.getTotalCalls () Type of call (string): Local Source Number (string): txtOrderNumber.getText () Destination Number (string): txtDef...
asked by 22.11.2016 / 04:45
1
answer

Change status if date is equal to or greater than today

I have this code: $activox_count_query = tep_db_query("select * from " . TABLE_ORDERS . " o, " . TABLE_GANTS . " g where o.orders_status = '32' and g.orders_id = o.orders_id and g.title = 'Activar Servicio' and g.start >...
asked by 23.11.2016 / 19:48
3
answers

Warning: mysqli_stmt :: bind_param (): Number of elements in type definition string does not match number of bind variables in /pg2.php on line 318

I am writing an INSERT statement and I have an error that I can not solve in the following statement: $stmt->bind_param("$tipo_var", $insert_valores); It happens that the variable $ var_type is enclosed in commas, so that the types of ea...
asked by 14.11.2016 / 23:59
1
answer

How to do operations with table fields in mysql?

I have a form that sends data to a table in mysql called (regis) and it has the fields (Name, Address, Phone, Job_ID, Amount, Date_input, Advance), in my field (Job_id) goes the value of my option selected, since I put a field with several optio...
asked by 09.11.2016 / 06:18
2
answers

Foreach with two array

I have two arrays that come out of two select multiple that I want to combine to store them in mysql I am using a foreach to go through one of them but I would like to know if there is the option to go through both and store them, so far this...
asked by 28.12.2016 / 20:19
1
answer

Put this function mysqli mysqli_real_escape_string

I have this function to insert in myqli function Insertar_Datos() { global $Conectar; $Parametros = func_get_args(); $InDatos = "INSERT INTO '".$Parametros[0]."' (".$Parametros[1].") VALUES (".$Parametros[2].");"; $...
asked by 27.12.2016 / 21:56
1
answer

Recursive MySQL query to parents and siblings

   The idea is to launch a single query which when you insert or modify a task, either the parent task (that your parent_task_id points to null) or a child task (that your parent_task_id points to the id of your parent task) updates the hour...
asked by 30.12.2016 / 13:49
1
answer

Large Decimals in Mysql

I want to know what kind of data to use for numbers that can be decimals but very high, like 10'000'000,123. I'm going to use it in Mysql, Java and Javascript. Thanks in advance.     
asked by 27.10.2016 / 17:20
2
answers

Download MYSQL on mac

what happens esque I have tried in a thousand ways to download mysql on mac, I read all the steps they give me on their page, and never ask for a password, or give it to me by default (as it says on the page) link Could someone who has install...
asked by 03.11.2016 / 18:45