Questions tagged as 'mysql'

Tagged questions
0
answers

How to correctly display pagination?

I made a part of my paging system but it always shows the maximum number of products in my bank and in the search I specified the name. Type I do the search for Leonardo in my bank has Leonardo registered and 8 more people there he brings me...
asked by 13.09.2015 / 04:11
1
answer

Join repeated results - PHP [duplicate]

Good morning everyone, I have a question to join repeated results in the query in Mysql made by PHP. This is the code that I'm using at the moment it removed the first retry of values in the query, but there is another field that should also...
asked by 14.09.2015 / 13:56
0
answers

Repeat template on multiple pages with PHPWord

Friends, I would like to use PHPword to generate company spreadsheets, so I generate a single docx with all the worksheets for easy printing. I thought about using a template, where I would change the days table, manually putting Satur...
asked by 26.07.2015 / 18:22
0
answers

Best way to work with hierarchical data in MySQL for a system with a hierarchy constant register

I have a table where I store user records where each user was indicated by another user, so I then maintain a ID column and a PARENT_ID column. There are 2 ways to work with hierarchy in MySQL , they are: Adjacency List Mode Nested...
asked by 25.07.2015 / 02:49
0
answers

Pagination PHP and MySQL

I created a search page with two search fields, it is working and everything is ok, so when I search I would like to page, and I am doing something wrong. My code. <?php $conexao =mysqli_connect($host,$user,$pass,$bank); $pagina = (...
asked by 02.08.2015 / 23:18
1
answer

I can not update a field in CakePHP with $ this-Model-saveField ()

I can not update a particular field in CakePHP. When you run $this->OrdemServico->saveField() , it simply does not execute. Code: class OrdemServico extends AppModel { public $name = "OrdemServico"; public $useTable...
asked by 03.08.2015 / 21:56
0
answers

error in mysql update

I'm getting this error when I try to update with mysql in asp. Microsoft VBScript compilation error '800a03ee' Expected ')' /postos/reg.asp, line 525 set ins_regenf1 = conn.Execute("UPDATE reg SET hemo ='"&hemo &"' WHERE id_reg='"&a...
asked by 25.08.2015 / 12:26
0
answers

How can I make a permission window just like facebook! [closed]

I have a news site and I do not know how to make this system! how to make that same window of access to data access from facebook.     
asked by 20.07.2015 / 20:27
0
answers

Making MySQL UPDATE in database DB according to MySQL SELECT in DB2 database

I need to do UPDATE in an (office) field of a database (investor) database (b2c) on my site. However, this UPDATE will depend on a SELECT query that is made in another database from another site (both sites belong to the same company). The two b...
asked by 26.08.2015 / 20:47
1
answer

Delete From Database without deleting related objects

I have a system on which to register Instructors and Students, each Instructor may have several Students under supervision and each Student may have only one Instructor or no Instructor. My problem is that when deleting an Instructor, student...
asked by 06.08.2015 / 22:01