Questions tagged as 'mysql'

0
answers

JPA Hibernate two entities with same name, always saving in the same entity

I have jCombobox where all entidades students are loaded. It happens to have two entities with the same name (two students Rodrigo Silva for example). Both are loaded into combo . With gravar data in banco , i...
asked by 11.04.2016 / 12:27
0
answers

SQL Query for Message System

I am modeling a base for exchanging messages between users, and I have the following tables, user , user_friend and user_friend_message . The user table stores all users of the system, user_friend makes the frien...
asked by 10.04.2016 / 06:32
0
answers

How to Get Results Close to a Specific

I'm trying to get results close to a specific record. I tried to use ABS, but I could not do it using it. The result limit is 5 . Data MARCA NOME_MARCA MEDIA 8 TOYOTA 100 11 HONDA 100 5...
asked by 26.10.2016 / 16:19
3
answers

How to convert a MySQL connection to MySQL? [duplicate]

I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works. The first file is: <?php include_once("/pasta/connectserver.php"); $table = "rjpsync_tag, rjpsync_i...
asked by 17.09.2014 / 13:47
2
answers

How to insert date and datetime into a table in MySQL?

The big problem is that after insert , all values that have date, are zeros and in the format yyyy-dd-mm and not dd/mm/yyyy , as it was initially inserted. How can I enter these values in the formatting I desire?     
asked by 30.05.2014 / 16:04
2
answers

Find more data after finding nothing related to ID

I am doing a 4x4 array system for a client and am having a difficulty in the following question: The system has to check if the indicated to be checked already has 4 people in the network, if there is then look at the next indicated next, until...
asked by 09.04.2016 / 08:18
1
answer

How to select all the tables that contain the field with the same name?

I need to look up all the "id_category" fields in a particular database, and bring up a list of tables that contain this field in common, which in this case is the foreign key of the "sis_category" table.     
asked by 08.04.2016 / 21:36
2
answers

Get highest and lowest id with status = 1

I have a table in the multi-line database, I wanted to get the highest id, which has status = 1, how can I do this with php? The id is one column of the table and the status is another. Then I also want to know how to get the least elevate...
asked by 06.03.2016 / 14:46
1
answer

Friends System with PHP [duplicate]

Hello, I would like to know how to create a friendships system for my facebook-style application. I'm not making a social network, but I need to implement that system. I have a table of users where I store data like id and username of the r...
asked by 09.04.2016 / 19:23
1
answer

Enter value of a radio button in the database

I have: <label class=""> <input name="user_perfil" type="radio" value="administrador"> Administrador </label> <label class=""> <input name="user_perfil" type="radio" value="cliente"> Cliente...
asked by 27.04.2016 / 04:18