Last 5 registered members.
#9

You can try union select.

PHP код:
$query mysql_query("(SELECT * FROM `dsb_user_profiles` LIMIT 5) UNION (SELECT * FROM `dsb_user_photo` LIMIT 5) ORDER BY `id` DESC");
while(
$row mysql_fetch_assoc($query)) 

    
$admin $row['_user'];
    
$image $row['photo'];
    echo 
"$admin"
    echo 
"<img src=\"$image\">";

If you don't care about duplicates, then do:

PHP код:
$query mysql_query("(SELECT * FROM `dsb_user_profiles` LIMIT 5) UNION ALL (SELECT * FROM `dsb_user_photo` LIMIT 5) ORDER BY `id` DESC");
while(
$row mysql_fetch_assoc($query)) 

    
$admin $row['_user'];
    
$image $row['photo'];
    echo 
"$admin"
    echo 
"<img src=\"$image\">";

Reply


Messages In This Thread
Last 5 registered members. - by Face9000 - 17.10.2013, 11:30
Re: Last 5 registered members. - by Konstantinos - 17.10.2013, 11:36
Re: Last 5 registered members. - by Face9000 - 17.10.2013, 11:44
Re: Last 5 registered members. - by Konstantinos - 17.10.2013, 11:47
Re: Last 5 registered members. - by Face9000 - 17.10.2013, 11:50
Re: Last 5 registered members. - by tyler12 - 17.10.2013, 12:04
Re: Last 5 registered members. - by Face9000 - 17.10.2013, 12:39
Re: Last 5 registered members. - by tyler12 - 17.10.2013, 12:50
Re: Last 5 registered members. - by gtakillerIV - 17.10.2013, 13:03
Re: Last 5 registered members. - by Face9000 - 17.10.2013, 18:29

Forum Jump:


Users browsing this thread: 1 Guest(s)