WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė LeBro· 2008 Bir. 26 14:06:12

bandžiau iš photogallery.php failo persidaryti, kad šalia siuntinio žvaigždučių pavidalu rodytų to siuntinio narių vertinimą ir iš tokios užklausos :

$result = dbquery(

      "SELECT tp.*, ta.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes

      FROM ".$db_prefix."photos tp

      LEFT JOIN ".$db_prefix."photo_albums ta USING (album_id)

      LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id

      LEFT JOIN ".$db_prefix."ratings tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P'

      WHERE photo_id='$photo_id' GROUP BY tp.photo_id"

   );

gavau tokia eilute :

$result = dbquery(

               "SELECT tp.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes

               FROM ".$db_prefix."downloads tp

               LEFT JOIN ".$db_prefix."users tu ON tp.download_author=tu.user_id

               LEFT JOIN ".$db_prefix."ratings tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='D'

               WHERE download_id=$download_id GROUP BY download_id ORDER BY download_order LIMIT $rowstart,".$settings['thumbs_per_page']

            );

bet meta kazkokia sql klaida :|

eilute, atvaizduojanti nariu vertinimus :

<td width='70%' class='tbl2'><b>Reitingas:</b> ".($data['count_votes'] > 0 ? str_repeat("<img src='".IMAGES."star.gif' alt='*' style='vertical-align:middle'>", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."</td>\n</tr>\n";

dekui uz bet kokia pagalba :)

Redagavo LeBro· 2008 Bir. 26 14:06:32