10_10

SELECT * FROM q_produtproject

mainchkinfo01 메인상단 value 1

0 = 1342 = 20210325163437
1 = 1305 = 20210315180857
2 = 1242 = 20201221200611
3 = 1239 = 20201219154821
4 = 1163 = 20200707164402
5 = 1162 = 20200707160149
6 = 1127 = 20200606193050
7 = 1105 = 20200513205250
8 = 1038 = 20200314152649
9 = 955 = 20191230144025
10 = 868 = 20190903203515
11 = 859 = 20190824144456
12 = 840 = 20190726141655
13 = 808 = 20190706203439
14 = 806 = 20190703225519
15 = 803 = 20190701192949
16 = 800 = 20190627123040
17 = 772 = 20190521180237
18 = 673 = 20190125121930
19 = 631 = 20181217124420

mainchkinfo03 세부상단 value 1

0 = 1343 = 20210326002855
1 = 1342 = 20210325163437
2 = 1305 = 20210315180857
3 = 1242 = 20201221200611
4 = 1239 = 20201219154821
5 = 1209 = 20201102202432
6 = 1208 = 20201102183219
7 = 1127 = 20200606193050
8 = 1105 = 20200513205250
9 = 1038 = 20200314152649
10 = 999 = 20200208201106
11 = 924 = 20191106181538
12 = 923 = 20191106175902
13 = 922 = 20191106175629
14 = 903 = 20191021195757
15 = 902 = 20191021195613
16 = 899 = 20191016194738
17 = 897 = 20191015180458
18 = 895 = 20191015120838
19 = 889 = 20191012151803
20 = 888 = 20191012151630
21 = 868 = 20190903203515
22 = 859 = 20190824144456
23 = 853 = 20190815204651
24 = 851 = 20190814160149
25 = 840 = 20190726141655
26 = 835 = 20190723014324
27 = 834 = 20190723014021
28 = 822 = 20190716194055
29 = 820 = 20190714205852
30 = 819 = 20190714205703
31 = 818 = 20190714205509
32 = 817 = 20190714204218
33 = 812 = 20190709141146
34 = 811 = 20190708001245
35 = 810 = 20190708000905
36 = 808 = 20190706203439
37 = 806 = 20190703225519
38 = 803 = 20190701192949
39 = 800 = 20190627123040
40 = 751 = 20190503233254
41 = 730 = 20190420180233
42 = 718 = 20190409191834
43 = 714 = 20190404142322
44 = 691 = 20190228170735
45 = 673 = 20190125121930
46 = 670 = 20190119191643
47 = 667 = 20190115232113
48 = 659 = 20190113003732
49 = 651 = 20190108001946
50 = 631 = 20181217124420
51 = 628 = 20181210195958
52 = 624 = 20181210133813
53 = 621 = 20181208023503
54 = 610 = 20181129205257
55 = 596 = 20181127190605
56 = 584 = 20181111195930
57 = 578 = 20181022150731
58 = 577 = 20181021144356
59 = 576 = 20181021131557
60 = 574 = 20181017114412
61 = 572 = 20181015231723
62 = 539 = 20180806161308
63 = 528 = 20180726150446
64 = 511 = 20180630144221
65 = 467 = 20180428223453
66 = 461 = 20180422161929
67 = 452 = 20180408142255
68 = 427 = 20180211134729
69 = 405 = 20180103143114
70 = 401 = 20171224001428
71 = 376 = 20171031115053
72 = 276 = 20170325183925
73 = 233 = 20170108101435
74 = 185 = 20161123210919

//메인신규20개유지
$main_chk = "UPDATE q_produtproject SET mainchkinfo01 = '' where mainchkinfo01 = '1' ORDER BY d_date DESC LIMIT 20, 50 ";
db_query($main_chk , $DB_CONNECT);

//세부상단인기
$sub_chk = "UPDATE q_produtproject SET mainchkinfo03 = '' where mainchkinfo03 = '1' ORDER BY d_date DESC LIMIT 10, 90 ";
db_query($sub_chk , $DB_CONNECT);

작동안됨

전환

//메인신규20개유지
$main_chk = "SELECT * FROM q_produtproject where mainchkinfo01 = '1' ORDER BY d_date DESC LIMIT 20, 50 ";
$MCK = db_query($main_chk , $DB_CONNECT);

    while($RMCK=db_fetch_array($MCK)
    {    

echo $RMCK['uid'];
 //db_query("UPDATE q_produtproject SET mainchkinfo01 = '' where mainchkinfo01 = '1' " AND uid ='{$RMCK['uid']}' , $DB_CONNECT);
    }

//세부상단인기

//메인신규20개유지
$sub_chk = "SELECT * FROM q_produtproject where mainchkinfo03 = '1' ORDER BY d_date DESC LIMIT 10, 90 ";
$SCK = db_query($sub_chk , $DB_CONNECT);

    while($RSCK=db_fetch_array($SCK)
    {    

echo $RSCK['uid'];
 //db_query("UPDATE q_produtproject SET mainchkinfo03 = '' where mainchkinfo03 = '1' " AND uid ='{$RSCK['uid']}' , $DB_CONNECT);
    }