dynamic images & query of a query how?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



ok after some fumbling i was able to get images to load in a recordset
but looks goofy

<img src="
<?php do {  ?>

<?php if (!(strcmp($row_rsForumUser['ID_MEMBER'],
$row_rsMember['ID_MEMBER']))) {echo $row_rsForumUser['avatar']; } ?>
      <?php
} while ($row_rsForumUser = mysql_fetch_assoc($rsForumUser));
  $rows = mysql_num_rows($rsForumUser);
  if($rows > 0) {
      mysql_data_seek($rsForumUser, 0);
	  $row_rsForumUser = mysql_fetch_assoc($rsForumUser);
  }
?>
">


it would be alot simpler if a do a join on 2 sepperate tables from 2 dirrent
data sources..
how?? would i combine the 2 recorsets below on
rsMember.ID_MEMBER = rsForumUser.ID_MEMBER
you know??

mysql_select_db($database_conTL, $conTL);
$query_rsMember = "SELECT memberId, ID_MEMBER, memberName, memberEmail,
memberDescription, memberContact, memberLevelId FROM member WHERE
memberLevelId = 1 ORDER BY memberName ASC";
$rsMember = mysql_query($query_rsMember, $conTL) or die(mysql_error());
$row_rsMember = mysql_fetch_assoc($rsMember);
$totalRows_rsMember = mysql_num_rows($rsMember);

mysql_select_db($database_conForums, $conForums);
$query_rsForumUser = "SELECT ID_MEMBER, memberName, emailAddress,
personalText, signature, avatar FROM teamtime_members ORDER BY
teamtime_members.memberName";
$rsForumUser = mysql_query($query_rsForumUser, $conForums) or
die(mysql_error());
$row_rsForumUser = mysql_fetch_assoc($rsForumUser);
$totalRows_rsForumUser = mysql_num_rows($rsForumUser);

Thanks Guys!
_paul


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux