За последние 24 часа нас посетили 19144 программиста и 1644 робота. Сейчас ищут 852 программиста ...

Не все записи выводятся в цикле

Тема в разделе "PHP для новичков", создана пользователем LAlexS, 19 янв 2012.

  1. LAlexS

    LAlexS Активный пользователь

    С нами с:
    12 авг 2010
    Сообщения:
    179
    Симпатии:
    0
    Адрес:
    Екатеринбург
    В базе три записи, отличаются только строкой где id сессии, одна не выводится, хотя отвечает всем условиям запроса

    Код (Text):
    1.  
    2. $user = $_SESSION['valid_user'];
    3. $products_exist = mysql_query ("SELECT * FROM shopping_cart WHERE cart = '1' AND (session = '$id_session' OR user = '$user_ids')");
    4. $pexist = mysql_num_rows($products_exist);
    5. if (empty($user))
    6. {
    7. $user_exist = mysql_query("SELECT tp.onoff, tp.id, tp.model_name, tp.price_normal, tp.image_main, tp.parent_brand, tb.brand_name, tb.bid, tc.synonym, ts.product, ts.session, ts.type, ts.id_cart, ts.cart, ts.qty FROM product_info AS tp LEFT JOIN brands AS tb ON (tp.parent_brand = tb.bid) LEFT JOIN categories AS tc ON (tp.parent_categorie = tc.id) LEFT JOIN shopping_cart AS ts ON (tp.id = ts.product) WHERE ts.session = '$id_session' AND tp.onoff = 1 AND ts.cart = 1") or die("Error! ".mysql_error());
    8. $user_list = mysql_fetch_array ($user_exist);
    9.  
    10. $summ_list = mysql_query("SELECT SUM(".$user_list['price_normal']."*qty) FROM shopping_cart WHERE cart = '1' AND session = '".$id_session."'");
    11. $summ = mysql_result($summ_list,0,0);
    12. }
    13. else
    14. {
    15.  
    16. $user_exist = mysql_query("SELECT tp.onoff, tp.id, tp.model_name, tp.price_normal, tp.image_main, tp.parent_brand, tb.brand_name, tb.bid, tc.synonym, ts.product, ts.session, ts.user, ts.type, ts.id_cart, ts.cart, ts.qty FROM product_info AS tp LEFT JOIN brands AS tb ON (tp.parent_brand = tb.bid) LEFT JOIN categories AS tc ON (tp.parent_categorie = tc.id) LEFT JOIN shopping_cart AS ts ON (tp.id = ts.product) WHERE tp.onoff = 1 AND ts.cart = 1 AND ts.user = '".$user_ids."'") or die("Error! ".mysql_error());
    17. $user_list = mysql_fetch_array ($user_exist);
    18. $summ_list = mysql_query("SELECT SUM(".$user_list['price_normal']."*qty) FROM shopping_cart WHERE cart = '1' AND user = ".$user_ids."");
    19. $summ = mysql_result($summ_list,0,0);
    20. }
    21. if (!empty($user_exist))
    22. {
    23. while ($user_list = mysql_fetch_array ($user_exist))
    24.     {echo "<tr>
    25.     <td class='img_in_cart'><img src='img/".$user_list['image_main']."' width=70px height=100px></td>
    26.     <td class='name_in_cart'>".$user_list['synonym']." ".$user_list['brand_name']." ".$user_list['model_name']."</td>
    27.     <td class='type_in_cart'>".$user_list['type']."<input type=hidden name=type[] value='".$user_list['type']."'></td>
    28.     <td class='qty_in_cart'><input name=qty[] type=text value=".$user_list['qty']." class='qty'> x </td>
    29.     <td class='price_in_cart'>".$user_list['price_normal']." рублей<input type='hidden' name=price[] value='".$user_list['price_normal']."'></td>
    30.     <td class='delete_in_cart'><a href='delete_from_cart.php?good=".$user_list['id_cart']."' class='delincart'>Удалить из<br>списка</a><input type=hidden name=id[] value=".$user_list['id']."><input type=hidden name=id_cart[] value=".$user_list['id_cart']."></td>
    31.     </tr>"
    32.     ;}
    33.     echo "<tr><td colspan='5' class='scart_summline'></td><td></td></tr>
    34.         <tr>
    35.         <td></td>
    36.         <td></td>
    37.         <td align='right'>Итого:</td>
    38.         <td></td>
    39.         <td align='right'>".$summ." рублей</td>
    40.         <td></td>
    41.         </tr>";
    42. }