Questions tagged as 'mysql'

Tagged questions
3
answers

How to do PHP and MySQL pagination?

I want to make a pagination on my blog. I will not have 50 posts on the first page, so I want to limit the page to the last 15 posts added and then clicking the "older posts" button will show me the oldest posts. In the background I do not want...
asked by 23.07.2014 / 16:14
0
answers

How to display photo saved in the database?

People, how do I display photos saved in my database? I want to make it as a gallery that has the option of the administrator delete the photo or add a new one at any time.     
asked by 30.11.2017 / 21:36
1
answer

Problems with mysql

So, guys, I did a shopping cart in php using wampserver. I created the DB in mysql and created two BD ones with the name "mxmaster" and another with the name "shop". I made the connections all right in php, creating cart, products, home, through...
asked by 22.11.2017 / 01:10
0
answers

Separate MySql result in blocks in PHP

I have a real estate table divided into several categories and I want to list them on my PHP page. The detail is that I wish that in one region of the page are listed the houses, in another the apartments and so on. In other situations I did a s...
asked by 06.11.2017 / 18:36
1
answer

table is not created in mySQL

create database mbsys default character set utf8 default collate utf8_german2_ci; '' this generates normal '' create table PESSOA ( ID_PESSOA int (10) not null, NOME varchar (40) not null, CPF int (11) not null, NASCIMENTO date not null, SEX...
asked by 09.11.2017 / 15:11
1
answer

Update a multi-student MySQL field

I have a student table where you have a presence field where present and are missing. When I created the field, I left everyone as away , and now I need to list and change some to present . I would like to change all at once, but I do no...
asked by 05.11.2017 / 00:38
1
answer

Edit status of multiple records with checkbox checked?

I need to send an array with the ids of the records that have the checkbox checked, to edit the status field at one time. Note1: All records will suffer the same change listed in a select. Note2: I can edit each record individually through a lin...
asked by 06.11.2017 / 13:50
1
answer

Dynamic Table with Ajax and JSP

I'm learning Java Web and would like to know if they could help me in the following: I have a form that I enter data in the bank, and under it a table in which I make the listing of what was inserted in the bank, however what happens is the foll...
asked by 06.11.2017 / 12:10
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
0
answers

Group by only 1 result

I have a problem with my query in MySQL: SELECT * FROM 'campeonatos' INNER JOIN 'jogos' ON 'campeonatos'.'camp_id'='jogos'.'campeonato_id' WHERE 'jogos'.'inicio' > "2017-10-30 00:00:00" ORDER BY 'campeonat...
asked by 30.10.2017 / 15:35