I'm trying to get the posts count inside my product category page loop (Woocommerce), but it just doesn't work. Does anyone knows why? Woocommerce uses the same file archive-product.php for displaying both Shop Page and Product Category Page. In my…
This query lists out the distinct order numbers in Woocommerce that have order either of two products, where the orders are in a status called 'wc-on-hold'. The query does work, but if I comment back in the AND COUNT(t1.ID)=2 it…
I just upgraded my PHP Version from 5.6 to 7.4. I used count() function in my page, example: $watch_server_count = count($watch_server); if ($watch_server_count > 0) { foreach ($watch_server->table as $key=> $watch_server_rows) { } } Warning: count(): Parameter must be an…
I have the following array with sub arrays [0] through [9]. I want to test the array and see if there is One sub array or more than one. Why? Because sometimes I get one record back from some tables…
I've copied the W3 schools code for performing a mysqli row count function, but when I input my variables, the returned result is always '1'. I have checked my SQL code by entering it directly into phpMyAdmin, which returns the…
I have the following JSON that comes back from an API: { "Statement": [{ "Sid": "Group1", "Resource": "arn:aws:ecs:*:777744445555:task-rendition/${aws:PrincipalTag/Service}-*:*", "Effect": "Allow" }, { "Sid": "Group2", "Resource": [ "arn:aws:ecs:*:777744445555:task-definition/${aws:PrincipalTag/Service}-*:*", "arn:aws:ecs:*:777744445555:task-petition/${aws:PrincipalTag/Service}-*:*", "arn:aws:ecs:*:777744445555:task-fruition/${aws:PrincipalTag/Service}-*:*" ], "Effect": "Allow" } ]} When I apply these commands I…
I have the next query to get the 15 most sold plates in a place: This query is taking 12 seconds to execute over 100,000 rows. I think this execution takes too long, so I am searching a way to…
I'm trying to gather "followers" for a specific user (#1 in this code). I'm doing my primary select from followers as the column following will have user #1 and followers.userid will have the userid of the person doing the following.…
Can't get this. How to determine size of an tep_db_fetch_array inside a while loop? I would like to do this: $i=0; while($a = tep_db_fetch_array($query)){ if($i==5){ // start a div i.e. } //do sth here if($i>=count($a)){ //close the div i.e. }…
1st query; both tables contain all categories_ids SELECT * FROM categories c, categories_description cd WHERE c.categories_id = cd.categories_id ORDER BY sort_order, cd.categories_name 2nd query; this table maybe hold a categories_id SELECT count(*) AS total FROM products_to_categories WHERE categories_id = "'+…