Questions tagged as 'mysql'

Tagged questions
1
answer

How to return only unmatched records in a JOIN? [duplicate]

I have a question regarding the use of JOIN in SQL in this case: I have a produtos table and a destaques table that contains the id of the product. I need to make a query that returns only the records that are n...
asked by 17.10.2016 / 00:50
1
answer

How do I populate a listbox c # mysql

How do I populate a ListBox with C # and mysql and at the same time put the value of each record? So far I've been able to set up the name but not the code for each one: Mat_sel.Items.Add(reader["mat_nome"]).ToString();     
asked by 06.01.2018 / 19:38
1
answer

Break apart, taking part of the text

I have a multiple select that saves the following format in the database: 1-Azul,2-Verde,3-Vermelho,4-Preto,5-Branco Now I need to break this variable so I can show the result, but I need to remove the comma, just get the part after the "-"...
asked by 08.12.2017 / 11:47
0
answers

Flexible Search filter

I have a page with a search filter with the options "service", "state" and "city" and a submit button that redirects to the page where a table with the already filtered records will appear. But currently the filter only works if the user only...
asked by 06.12.2017 / 11:59
3
answers

Count sql results in table having or not values

I have a subcategorias table and I have another anuncios , where it has the id of the subcategory. I need to fetch all subcategories and return by subcategory the number of ads it has, the problem is that I'm already generating the...
asked by 06.12.2017 / 12:53
1
answer

Insert variable in href in php with mysql

I am trying to pass the value of the Company_ID in my select from my href, but to no avail. Can someone give me an address please? This is my href: <div class="box-footer clearfix"> <a href="<?=site_url('dashboard/finance...
asked by 06.12.2017 / 12:01
1
answer

Inner Join returning empty

I have a SELECT to return a list of products, but I want them to be differentiated by input and output, contains and does not contain ... Note: I WANT TO GET THE LATEST MOVEMENT OF EACH PRODUCT Select that I have so far SELECT DISTIN...
asked by 22.12.2017 / 14:22
0
answers

Parameter error always null

I'm trying to make a register system when I click the button, everything happens but the parameter is always getting null. (Even though I define it in a string) String url = ""; String parametros = ""; Connection: public static String pos...
asked by 21.12.2017 / 01:53
1
answer

How do I pick up unseen items?

I use the following select to grab the items already seen: $sql = $conn->query("SELECT * FROM views b, news a WHERE a.status = 'true' AND a.id = b.id_news AND b.ip = '$ip' ORDER BY a.id DESC LIMIT 6"); Where: $ip = $_SERVER['REMOTE_...
asked by 21.12.2017 / 00:58
0
answers

Calling data from a form on the same HTML page

I want to call data already entered in a form and use it on the same HTML page where I will use it in a SQL query. Depending on the number of municipalities, several IPL3 fields will be generated. The intent is to save the data to a table in...
asked by 08.12.2017 / 17:48