Questions tagged as 'mysql'

Tagged questions
1
answer

Custom plugin wp

I have the following code function app_searched_today_visitbh() { global $wpdb; $horas = $wpdb->get_var("SELECT time_format(timediff(now(),date_people),'%i%h') FROM today_people LIMIT 1"); return ("<span id='days_since'>$...
asked by 14.02.2017 / 04:30
2
answers

Wordpress: Post and user objects with the same ID

The project in which we are working requires assigning a personalized taxonomy to users who in turn are related to a custom post type, that is, we want to tag posts and users with the same custom term. The problem is that the user object gene...
asked by 20.01.2017 / 19:51
1
answer

Problem with ResultSet in Java

I am working with MySQL in Java and when I do querys I formulate them in a general way, I prepare them and execute them. When I get the ResultSet I give it to a method that processes it (Command Pattern), but when the response is obtai...
asked by 20.01.2017 / 18:51
1
answer

Can you use two @rownum in the same select?

With this select I visualize the field of the table person with a sequential number before the field name . SELECT @rownum:=@rownum+1 ‘fila’, nombre FROM personal t, (SELECT @rownum:=0) r; The output is something like this:...
asked by 12.01.2017 / 17:17
2
answers

Help creation of application

I want to create a CRUD type application to list information about the users of the company, the thing is that this application would only be used by 5 people in the company and they tell me that it is not necessary to be online on the web. I...
asked by 28.02.2017 / 02:28
2
answers

Error checking registry

My problem is when checking if there is a record in the database $category_id = $_POST["category_id"]; $name = $_POST["name"]; $lastname = $_POST["lastname"]; $address = $_POST["address"]; $email = $_POST["email"]; $phone...
asked by 28.02.2017 / 14:44
1
answer

How to eliminate in two tables?

I am developing a fixed assets management system and I have two tables where there are low acquired assets, one tables is bajasaf and the other is distribdebajas . In bajasaf the information is saved as the id_baja, fecha_...
asked by 27.02.2017 / 18:59
1
answer

Transform rare characters in mysql [duplicated]

I'm collecting data stored in database, and I've seen that there are some columns that have strange characters. Example (Extracted from php)    The sport is not being valued enough and the situation is very   fucked Example (Store...
asked by 10.01.2017 / 17:18
1
answer

Application rails with remote database

I'm starting in ruby on rails and I want to make an application connected to mysql , but the database is on a remote server. I have to create the database beforehand or I do it later from the console with rake db: create? Here's my datab...
asked by 19.01.2017 / 11:59
1
answer

Error trying to use connection with mysql in Apache Server Tomcat in the Cloud (hibernate)

I have an error trying to execute the execution of my web application on a web server called facilcloud (jelastic), my project is working with mysql hibernate, mongodb, java 1.6, spring mvc, bootstrap, maven among other tools. The problem I h...
asked by 31.12.2016 / 06:58