Tag: mysql

MySQL: Updating all rows setting a field to 0, but setting one row’s field to 1

Is there an efficient way to update a selection of rows’ field to 0, but set One of these rows to 1 based on an ID. Basically, I have multiple objects in a database, and I want to toggle between …

ASP.Net (C#) & SQL Server -or- PHP & MySQL for performance? [closed]

c# mysql php sql-server

Money, Staff, Skill and preference to open source or commercial is neutral. Let’s take the best of the best programmers (for arguments sake) and think about this: What will perform better overall: …

Why can’t CakePHP bake connect to MySQL running under EasyPHP on Windows Vista Ultimate?

cakephp cakephp-1.2 easyphp mysql php

I have CakePHP (cake_1.2.2.8120) and EasyPHP (3.0) installed on Windows Vista Ultimate. I followed the “baking” tutorials online and successfully set the database connection with the “cake bake” command from the CLI. I baked the controller for my “Users” table using the “php cake.php bake controller Users” command – worked fine. However, when I tried baking the view similarly, I

MySQL query to extract first word from a field

mysql php sql

I would like to run a query that returns the first word only from a particular field, this field has multiple words separated by spaces, I assume I may need to carry out some regex work to accomplish this? I know how to do this using a few ways in PHP but this would best be carried out on the

Select from MySQL records that sums

mysql php sum

I’m using PHP and MySQL. I have a table named quantity. Inside there are records of product name, product price and product quantity. Besides these, there are a few others that helps me select the last records based on date and position, as well as a GROUP BY the field named price because there are different quantities with different prices

Object-oriented-like structures in relational databases [closed]

database mysql oop php

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last year. Improve this question Folks, For the n-th time in a row, i’m hitting the same old problem again. It’s about “how do I map OOP

Application access server load

javascript mysql php

I have developed an application in PHP + JavaScript. I’m using MySQL as database support. Every account for this app will come with a subdomain… so the client Stardust would have stardust.mysite.com. I want to put the application files in a folder outside public_html and link every account from every subdomain created to this files folder through a config file

Limit a MySQL query to an even number of results

limit mysql mysqli php sql

I have a bit of PHP code which I need to return an even number of results from a MySQL database. I’m using the mysqli extension to execute my query. My code is approximately this at the moment: //…

MySQL Prepared statements with a variable size variable list

mysql php prepared-statement sql

How would you write a prepared MySQL statement in PHP that takes a differing number of arguments each time? An example such query is: The IN clause will have a different number of ids each time it is run. I have two possible solutions in my mind but want to see if there is a better way. Possible Solution 1

Algorithm for generating a random number

algorithm mysql php pseudocode random

I’m looking to generate a random number and issue it to a table in a database for a particular user_id. The catch is, the same number can’t be used twice. There’s a million ways to do this, but I’m hoping someone very keen on algorithms has a clever way of solving the problem in an elegant solution in that the