[SOLVED] using a function within a echo

[MasterACE14]

Evening Folks,

 

I'm having a little trouble getting a function to work properly within a echo. It seems to me that this problem is something really simple, but I just can't quite put my finger on it  :-\.

 

The function does execute within the echo, but its being displayed in the wrong order. I dont know whether it is a CSS problem, HTML problem or a PHP problem, or all of the above. Any help is greatly Appreciated!

 

Here's the echo:

<!-- Left Column -->
<div id = "leftcolumn">

<?php	echo '<span><b>Name</b>' . player_table("username") . '  </span>'; ?>

</div>

 

this is displaying:

ACEName

 

when it should really be more like this:

Name    ACE

 

Here is the CSS code for the span tag:

/* spacing */
span  { word-spacing: 30px }

 

Regards ACE

[sasa]

can we see player_table function

[MasterACE14]

// Select fields from the user table
function player_table($select) {
if (!isset($_SESSION['playerid'])) {

// Destroy the session
session_destroy();

// Automatically redirect to the homepage
header("Location: index.php?page=home");
}

$where = $_SESSION['playerid'];

$rs = mysql_connect( "localhost", "ace_ACE", "*****" );
$rs = mysql_select_db( "ace_cf" );

// SQL query for all entries in descending order
$sql = "SELECT `" . $select . "` FROM `cf_users` WHERE `id`='" . $where . "' LIMIT 1";
$rs = mysql_query( $sql ) or die('Query:<br />' . $sql . '<br /><br />Error:<br />' . mysql_error());

// This gets the data from the result resource
$query = mysql_result($rs,0,0);

echo $query;

};

[sasa]

in function change last line

echo $query;

to

return $query;

[MasterACE14]

Still does the same thing 

[suma237]

im not sure about it.Check this

 

echo $query;

 

};----WHY THIS SEMICOLON?

[sasa]

Still does the same thing 

are you shure to save changes in function

 

in your 1st code echo statesment first build string for output

in building string first call function (it print name on screen) and use what function return (in 1st code nothing)

after that print on page using '' for name

[MasterACE14]

I got it working now 

 

Thanks guys

 

Regards ACE