dynamic images & query of a query how?
| From: | Paul Ihrig | Date: | Fri, 16 May 2003 01:16:06 +0000 |
| Subject: | dynamic images & query of a query how? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27797@lists.php.net to get a copy of this message | ||
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