|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN3' order by goods_new desc, goods_date desc limit 8";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|
|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN2' order by goods_new desc, goods_date desc limit 4";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|
|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN5' order by goods_new desc, goods_date desc limit 4";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|
|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN1' order by goods_new desc, goods_date desc limit 4";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|
|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN8' order by goods_new desc, goods_date desc limit 4";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|
|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN9' order by goods_new desc, goods_date desc limit 4";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|
|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN6' order by goods_new desc, goods_date desc limit 4";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|
|
$que = "select * from shop_list where goods_regist=1 and upper_code='SN7' order by goods_new desc, goods_date desc limit 4";
$result = mysql_query($que, $conn);
$j=0;
while($row = mysql_fetch_array($result))
{
$code = $row["code"];
$upper_code = $row["upper_code"];
$middle_code = $row["middle_code"];
$goods_price = $row["goods_price"];
$goods_name = $row["goods_name"];
$goods_make = $row["goods_make"];
$goods_color = $row["goods_color"];
$goods_size = $row["goods_size"];
$goods_content = $row["goods_content"];
$goods_counter = $row["goods_counter"];
$regist_date = $row["regist_date"];
$goods_date = $row["goods_date"];
$goods_regist = $row["goods_regist"];
$goods_main_hit = $row["goods_main_hit"];
$goods_main_today = $row["goods_main_today"];
$goods_best = $row["goods_best"];
$goods_sub_best = $row["goods_sub_best"];
$goods_new = $row["goods_new"];
$goods_event = $row["goods_event"];
$imgurl1 = $row["imgurl1"];
$imgurl2 = $row["imgurl2"];
$imgurl3 = $row["imgurl3"];
$imgurl4 = $row["imgurl4"];
$imgurl5 = $row["imgurl5"];
$imgurl6 = $row["imgurl6"];
$imgurl7 = $row["imgurl7"];
$imgurl8 = $row["imgurl8"];
$imgurl9 = $row["imgurl9"];
$imgurl10 = $row["imgurl10"];
$que = "select shop_catagory_upper.upper_name,shop_catagory_middle.middle_name from shop_catagory_upper,shop_catagory_middle where shop_catagory_upper.upper_code = shop_catagory_middle.upper_code and shop_catagory_middle.middle_code='$middle_code'";
$result2 = mysql_query($que, $conn);
$row2 = mysql_fetch_row($result2);
$upper_name = $row2[0];
$middle_name = $row2[1];
if($j % 4 == 0)
{
?>
}
?>
|
|
|
if($goods_regist) {
?>
0 ¿ø
} else {
echo "Ç°Àý";
}
?>
|
|
|
if($j%4 == 3)
{
?>
}
$j++;
}
if($j%4 == 1) {
echo " | | | ";
} else if($j%4 == 2) {
echo " | | ";
} else if($j%4 == 3) {
echo " | ";
}
?>
|