echo database result problem 1

[krappleby025]

i have a code as follows

extract($row);
echo &quot;<tr>\n
<td width=\&quot;50%\&quot; bgcolor=\&quot;#FFFFFF\&quot;><font face=\&quot;MS Sans Serif\&quot; color=\&quot;#000000\&quot;><B><center>$username</td>\n
<td width=\&quot;50%\&quot; bgcolor=\&quot;#FFFFFF\&quot;><font face=\&quot;MS Sans Serif\&quot; color=\&quot;#000000\&quot;><B><center>$fullname</td>\n
</tr>\n
&quot;;

everything works except the $fullname echo.. it does not produce the record, the database results are called, and it just dont show it.. The $username works

any ideas

thanks

 

[sleipnir214]

Insufficient data for a meaningful answer.

How are you assigning values to the variable $fullname?

What have you done to verify that the above assignment is working correctly?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[krappleby025]

here is the full code

<?
$querydownline = &quot;select username, fullname from Members where sponsor = '$loggedin'&quot;;
$result = mysql_query($earningscheck) or die (&quot;couldn't execute query&quot;
while ($row = mysql_fetch_array($result) )
{
extract($row);
echo &quot;<tr>\n
<td width=\&quot;50%\&quot; bgcolor=\&quot;#FFFFFF\&quot;><font face=\&quot;MS Sans Serif\&quot; color=\&quot;#000000\&quot;><B><center>$username</td>\n
<td width=\&quot;50%\&quot; bgcolor=\&quot;#FFFFFF\&quot;><font face=\&quot;MS Sans Serif\&quot; color=\&quot;#000000\&quot;><B><center>$fullname</td>\n
</tr>\n
&quot;;
}
?>

 

[krappleby025]

shoot think ive just sean it lol

 

[sleipnir214]

You mean the fact that you're using a different query than the one that will fetch the column &quot;fullname&quot; from the table?


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[krappleby025]

yes/

lol thanks for the help