Question : I have to update the custo field of the pedidos table based on the valor field of the […]
Tag: mysql
How to do ascending and descending listing in records with PHP
Question : My table looks like this ThroughPHP,IamlistingMYSQLdatabaserecordswithinaWHILELOOP.Iwouldliketoknowhowtodothissothat,byclickingonID,or,DATA,thedatawillbedisplayedinascendingordescendingorder. SCRIPTPHP: <?php$strSQL=”SELECT * FROM TABELA ORDER BY id DESC”; $rs = mysqli_query($conecta,$strSQL); […]
Updating application (C #) in real time with the Database (Mysql)
Question : I’m creating a client server application, the application would run on multiple machines using the same database (mysql) […]
Problem connecting multiple CodeIgniter databases
Question : I have an application where it connects to multiple databases, initially I use the database settings database.php . […]
Use missing ids
Question : After viewing this question I remembered of a problem that I have come across many times: Let’s suppose […]
Know the name of the object in JSON
Question : I have a JSON and I need to know the name of my object and the values it […]
Array of SQL conditions – PHP
Question : Good afternoon, I am sending a search filter for my DB, and I want to make these conditions […]
How to create a conditional index in MySQL?
Question : How to create a filtered index for a specific range of data? As far as I know, it […]
Error in query in bank with Linq
Question : Good evening! I’m trying to perform a query on a mysql table, using linq, and present that result […]
Is it possible to change databases in an existing system?
Question : I’m starting a project in ASP.NET MVC 5 with Entity Framework for a client, where it chose to […]