The myth of while? How can I make a "only once" object appear only once? Without being affected by other while?

my question is a bit complicated
the orange line is a while
color line is also a while
film, you can see that it has been duplicated (I use distinct, you can see that there is a problem)

on the right side of the shopping list is to show the name of the store
and then all the goods in the store
, so I have to print each store name
and then print each corresponding store

I"m completely stuck here now.
my goal is to print as many items as there are in the line
, but only one object in the color box will be fine!
if there is only one item (offline), then everything will be normal.
but if there are more than one item on the offline line, he will reorder more than one item. There are several identical
I would like to explain how to solve it?
how to write if it is a general way of thinking?

Php php7 mysql

Mar.31,2021

so there is a problem with the sql statement of the query. You should divide it into two queries: one query the data of the outermost while, and one query the while data of the blue picture
query the outermost data is a List, and then store the List information of the picture in a field
-- do not understand PHP, but have the same meaning

Previous: Antd-design generates an editable table, cell with a select control, how to control the display of this control through a click event

Next: Doubts about the transfer of parameters by getter in vuex

Batch updates to database?
I have a problem with batch updates hypothetically I am a loop printing out the box and product ID while($row = mysqli_fetch_array($data)){ <input type="hidden" name="cart_prod_id[]" value="<?=$row[ prod_id ];?>&qu...

Php php7 mysql mysqli mariadb

Mar.22,2021
How many times do you add append uploaded? And the replacement of attr src?
I wrote one after the user uploaded the video and selected it $( input[type=file] ).change(function() { var input = $(this); if(!!this.files && !!this.files[0]) { var reader = new FileReader(); reader.onload = functi...

Jquery javascript php php7 mysql

Mar.23,2021
After removing the important comparison number, it will not be able to display!
SELECT p.name AS pname, p.icon AS icon, p.price AS price, p.original_price AS original_price, p.prod_id AS prod_id, p.stock AS stock, p.views AS views, s.name AS sname FROM `pr...

Php php7 mysql

Mar.23,2021
If the classification is the same, then there is no need to show the same classification again?
I have a problem now join store product product store_id product store_id The check box is store_id , but I found that even if it is the same store_id, it will print out . What I want to achieve is that just show a store_id, and as long as t...

Php php7 mysqli mysql

Mar.28,2021
How can a certain KEY be skipped automatically at the same time?
$subtotal = $pdo->query( "SELECT s.quan as quan, s.price as price, p.store_id as store_id FROM `stock` as s JOIN product as p ON s.prod_id = p.prod_id " ); while ($row_ = mysqli_fetch_array($sub...

Php php7 mysql mysqli

Mar.28,2021
How do I generate numbers that are not duplicated when processing a list in while?
while ($row = mysqli_fetch_array($aa)){ $public_order_id = date( Ymd , time()).rand(1,999999); because there will be more than one br in an instant. my current idiotic approach is to use rand. , but 1999999 still has a chance to reproduce, bec...

Php php7 mysql mysqli

Mar.28,2021
How to add up the figures of the same day? Printed as correct json
this is the result of the query this is the php query code SELECT FROM_UNIXTIME(add_time, %Y-%m-%d ) as add_time, count(view_id) as viewTime FROM `view` GROUP BY `add_time` this is the whole php code header( Content-type: application j...

Json php php7 mysql mysqli

May.22,2021
How do I take out the value of foreach and update the table?
$keyyy = null; while ($r = mysqli_fetch_array($rs)){ $tagg = array($r[ name ]); foreach ($tagg as $key) { $keyyy = $key. , ; } } the printed result is 1,2,3,4,5, just why do I only have 5, when I update to the number table? ...

Php php7 mysql foreach

Jul.28,2021
There is no problem with the quantity when printing, but the number is wrong when sum?
SELECT ss.quan FROM `stock` as ss JOIN `order_record` as r ON r.order_id = ss.order_id WHERE ss.from = c AND r.from = c AND r.status = ing AND ss.prod_id = 120 GROUP BY ss.order_id ...

Php php7 mysql mysqli mariadb

Oct.17,2021
How to package some data pens into a collection, click on them, and then expand them according to the ID?
situation: uncertain orders are generated every day suppose there are eight orders generated today id status 1 2 3 4 5 6 7 8 I use loops to change the status of these eight orders to "shipping " . question: how can I tu...

Php php7 mysql mysqli mariadb

Dec.03,2021
Php an action is used in more than two places, how to propose it?
two hypotheses A $do->query( "INSERT INTO `abc` ( `public_order_id`, `add_time`, `status` ) VALUES ( {$public_order_id} , {$add_time} , ) &...

Php php7 mysql mariadb mysqli

Apr.04,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1ea98f3-1f65.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1ea98f3-1f65.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?