Questions tagged as 'mysql'

Tagged questions
2
answers

Modify textbox value when select changes

I have a table called articles , it has the following fields: article_id , des_articulo (description of the article cited) and article (article number) I have a form to register sanctions, where I use this table that contains the articl...
asked by 18.01.2017 / 16:17
1
answer

Sort the results of a query according to the results of another

I happen to have two tables, articles and likes . In the first, I keep a series of articles, and in the second, I keep the reaction of users to these articles. I want to sort the articles (article table) in order from most to least reactio...
asked by 18.01.2017 / 00:40
1
answer

mysql num row does not work for me

Hello, I need to add pages to my site. specifically it is a preview of a report of 3000 records and I want to show on each page 100 This is my query: $sql ="SELECT documento.* FROM documento LEFT JOIN ubicacion ON (ubicacion.documento_id = do...
asked by 17.03.2017 / 15:04
2
answers

Different contact form for each item listed [closed]

I mean, I need a different contact form for each user when they enter a category. That is, the website is classified ads, and the ads are listed by categories, I need a contact button that is repeated within the while loop that shows the ads,...
asked by 18.03.2017 / 05:13
1
answer

mysql relationships

I have a small problem and I have doubts. Taking this text as an example: "client contains the establishment, which in turn contains the lots" My intent is this: create table lotes ( id_lote int auto_increment primary key, desc_lote varc...
asked by 29.04.2017 / 15:44
1
answer

Load data from a database when pressing buttons (next and previous) No backspace

I have a system that shows "TIPS" of health contained in a database. I would like to add buttons next and previous The idea is that when you press next or previous one, change the nume_cons and then load the title, the description and the...
asked by 28.01.2017 / 14:24
2
answers

Error using mysql_num_rows [closed]

Could you help me with this little code? <?php include("../app/database.php"); if (isset($_POST['registrar'])){ if (($_POST['nombre']!='') && ($_POST['email']!='') && ($_POST['clave']!='') && ($_P...
asked by 20.01.2017 / 13:12
1
answer

How to change between lists or pages of records with buttons of NEXT or PREVIOUS in PHP?

I have a system to show health tips. I would like the next or previous click to change to the next tip that is contained in the database. I have already managed to generate a value that is a number less or more than the ID of each council but...
asked by 29.01.2017 / 02:10
1
answer

What is missing from my SQL sequence?

You see, I have to list some basic data for a sales report by dates, the problem I have is the following, if a client in the invoice 2 buys 10 articles I list the values of each article and what I need is that I totalized the total value of the...
asked by 12.02.2017 / 02:43
1
answer

Return values of a table separated by commas and access each value in specific

I have a list of checkbox in which the user selects and sends the form , they are saved in a array and put them in a data table, these are saved as for example: Chino, Árabe, Español . By sending a select to b...
asked by 10.02.2017 / 17:17