I am trying to update my table column but I keep getting one value for all the rows, what am I doing wrong? <?php $count = 1; while ( $count <= 30) { $fmle_img = "_src/img/profile/female/u$count.png"; $db->query("UPDATE users SET image=:image…
I have two tables that I am trying to join and display the count of transactions by year grouped by user_name. The data is from two separate tables: users and transactions. I need the output to have four total columns:…
i want to insert values in a table by using procedure i have 2 tables sales and products in a product table i have id , product_name,product_price, product_quantity and in sales table i have p_id and p_qty by using procedure…
I have data like below Amount currency Investors 250 USD Coinvest I 0 GBP Coinvest I 860 USD Paralell 0 GBP Paralell 121 USD PSLO 5 NULL PSLO I need output like below Amount currency Investors 250 GBP Coinvest I…
What is the best way to have the same entity field in many entities? For example an 'relatedEntity' will be appearing in 8 tables. class User { #[ORMColumn(length: 255)] private ?string $relatedEntity = null; } class User2 { #[ORMColumn(length: 255)]…
I am using codeigniter 4. I want to sum this data from my model. pow(data_training.area-avg(area),2) so I type like this : sum(pow(data_training.area-avg(area),2)) but it's turn out like this: error screenshot Please tell me how to sum the data values. Here…
I'm getting data from the database and want to present the data by year. Like this: 2013 Event A Event B 2012 Event X Event Y Etc. I've got this mysql query and PHP code which presents all the data…
I have sample data that looks like the following: fname lname x abc jkn test test gth yg-txs gb@y Need to write simple query to remove all special character and spaces, concat fname and lname put it in fullname column,…
Assume I have a table as follow: product date value A 1 2 A 2 0 A 3 3 A 4 0 B 1 1 B 2 0 C 1 1 C 2 2 C 3 4 I am trying…
I have the following table named Transactions where the timestamp column is in the Unix timestamp format with the minimum timestamp value being January 2008 and the maximum timestamp value is December 2008 (I'm only concerned with months for this…