select 2 query

[FT3]

Sveiki , ir radusies šada problēma.

 

Query izvada lietotāju nick , un pec id izvada balvas id , bet tada problēma ka izvada tikai 1 balvas id , bet balvas ir vairakas

 

<?php
include('inc/connect.php');
$rpp = '23';
$adjacents = 4;
$page = intval($_GET["page"]);
if($page<=0) $page = 1;
$reload = $_SERVER['PHP_SELF'];

$sql = "SELECT * FROM `members` ORDER BY `member_id`";
$result = mysql_query($sql);
$tcount = mysql_num_rows($result);
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1;
$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
mysql_data_seek($result,$i);
$query = mysql_fetch_array($result);
 $uid = $query['member_id'];
 $res_award = mysql_query("SELECT * FROM `inv_awards_awarded` WHERE `user_id` = '$uid'");
$award = mysql_fetch_array($res_award);

echo '
<table>
<tr>
<td>'.$query['name'].'</td>
<td>'.$award['award_id'].'</td>
</tr>
</table>
';
$i++;
$count++;
}
echo paginate_two($reload, $page, $tpages, $adjacents);
?>

Edited March 29, 2012 by FT3

[Vecteevs]

Ideja ir šāda

http://www.tizag.com/mysqlTutorial/mysqljoins.php

[FT3]

sorry nepareizi biju uzraksitjis , loabots

 

veram ciet , izmantoju while..

Edited March 29, 2012 by FT3