How to show more than 1 users with this code...

Posted on 16th Feb 2014 07:03 pm by admin

Hello,
i have a table that shows users only if I, as Administrator, want to be shown. But its showing just 1 user and i want to show at least 4. If i copy the code, or use loop, its showing the same user 4 times... How to make it show 4 different users? I tried with "LIMIT 1" changed to LIMIT 4, but nothing happens.
Here are the codes:
PHP code
Code: <?php
////////GET LANG IDS
$aValues = array();
$sSql = " SELECT
`languagevar_id`,
REPLACE(`defVarName`, 'home.', '') AS `key`
FROM `advFetMem_settings` WHERE `defVarName` LIKE '%home.%' ";
$rResult = mysql_query($sSql);
while( ($aRow=mysql_fetch_assoc($rResult)) )
$aValues[ $aRow['key'] ] = $aRow['languagevar_id'];
$smarty->assign('aCusLang_advFetMem', $aValues);

//GET SETTING
$sql ="SELECT `setting_username` FROM `se_settings` LIMIT 1";
$result = mysql_query($sql);
$aRow = mysql_fetch_assoc($result);
$bUserNames = $aRow['setting_username'] == 1 ? TRUE : FALSE;


$iTime = time();
$sql = "SELECT
`u`.`user_id` AS `userId`
FROM `advFetMem_info` AS `i`
INNER JOIN `se_users` AS `u`
ON `u`.`user_id` = `i`.`userid`
WHERE
'".$iTime."' BETWEEN `i`.`start` AND `i`.`end`
ORDER BY RAND()
LIMIT 1";
$result = mysql_query($sql);
$smarty->assign('aAdvFetMem', FALSE);
if( $aRow = mysql_fetch_assoc($result))
{
$tempUser = new se_user(Array($aRow['userId']));
$tempUser->user_displayname();
$aRow['username'] = $tempUser->user_info['user_displayname'];
$aRow['photo'] = $tempUser->user_photo("./images/nophoto.gif", TRUE);
$smarty->assign('aAdvFetMem', $aRow);
}
?>
TPL code
Code: {* include_advFetMem_home.tpl 2009-07-21 12:57:53 rhutton *}
{if $aAdvFetMem}

<div class='header'>{lang_print id=$aCusLang_advFetMem.featured_member}</div>
<div class='portal_content'>
<table cellpadding='0' cellspacing='0' align='center'>
<tr>
<td class='portal_member' valign="bottom" style="width:50%;">
<a href='./profile.php?user_id={$aAdvFetMem.userId}'>{$aAdvFetMem.username|truncate:15:"...":true}</a><br />
<a href='./profile.php?user_id={$aAdvFetMem.userId}'><img src='{$aAdvFetMem.photo}' class='photo' width='60' height='60' border='0' alt='' /></a><br />
</td>
</tr>
</table>
</div>
<div class='portal_spacer'></div>
{/if}
Thank you!

Your Answer:

Login to answer

Other forums

Change log of Cost centre change in Plant maintenance order
Hi,
How to view Change log of Cost centre in Plant maintenance order. Not visible thru 'Docume

Please Help my PHP Dating Function.
Hi everyone!

Well here is my code that displays this:

It works wonderful.

user validation always displaying invalid ? please help
Hello,

I have 2 accounts and there is a field in mysql called validated it can be either &quo

FROM_UNIXTIME($phpdate);
Hello,

I tried to use this :

$date = FROM_UNIXTIME($phpdate);

ANd I was t

How to display value in drop down list after form has been reloaded
Please bear with me as I am very new to php and html.

I have a form with several drop down me

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

Error querying database.
I get the above error when trying to insert some values to a datatable.
Here's the code :

Uploading/Downloading files stored in MySQL database
Hey all,

This problem just came up in my website and I'm having a hard time figuring out what

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S