[Resolved] show x characters length for username

[abda53]

i have a user that has a login with a ton of characters, i want to show only 15 characters, and the rest with usernamegoesher...

not sure how to do that. heres my code

$sql = "SELECT user_id, user_name, user_joindate FROM 4images_users WHERE user_level != 1 ORDER by user_joindate DESC LIMIT 5";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {

$user_new_member_list .= format_date($config['date_format'], $row['user_joindate']). '&nbsp;&nbsp;<a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].'</b></a><br>';
}

and heres the length code.. or an example of it. what do i do to put it in?

$user_name = substr($user_name, 0, 15).((strlen($user_name) > 15) ? "..." : "");

[maqmus]

I woud do it this way:

if(strlen($user_name)>15) {
$user_name = substr($user_name,0,15)."..."; }

[abda53]

thanks

im having problems on where to put that in..

$sql = "SELECT user_id, user_name, user_joindate FROM 4images_users WHERE user_level != 1 ORDER by user_joindate DESC LIMIT 5";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {

$user_new_member_list .= format_date($config['date_format'], $row['user_joindate']). '  <a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].'</b></a><br>';
} 

$site_template->register_vars(array(
"user_new_member_list" => $user_new_member_list
));
unset($user_new_member_list); 

[abda53]

nevermind i figured it out

$sql = "SELECT user_id, user_name, user_joindate FROM 4images_users WHERE user_level != 1 ORDER by user_joindate DESC LIMIT 5";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {

if(strlen($row['user_name']) >10) {
$user_name = substr($row['user_name'],0,10)."..."; }
	if(strlen($row['user_name']) <10) {
$user_name = $row['user_name']; }

$user_new_member_list .= format_date($config['date_format'], $row['user_joindate']). '  <a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$user_name.'</b></a><br>';
} 

[maqmus]

____
if(strlen($row['user_name']) >10) {
$user_name = substr($row['user_name'],0,10)."..."; }
if(strlen($row['user_name']) <10) {
$user_name = $row['user_name']; }

I think for the second if statement you'd better use else or:

if(strlen($row['user_name']) <=10) {

Otherwise isn't defined what to do if length is exactly 10.

[abda53]

ahh good eye didnt think about that one