Neverside

replacing text with image, prob

.....

well basically i want to add a it to my script but when i use an array it stopes my, my sql array working and i dont know how to stop it...

here is my code

PHP:

<?php

$query = "SELECT * FROM threads where thread_id='$thread' AND thread_top='0'";
$result = mysql_query($query);
// Now we print out the results, starting by making a table
echo ("<table border = '0' width = '100%' align='center'>");
while ($rows = mysql_fetch_row($result))
// Here we make the script keep making new rows until all the links in our database are shown, this is called a loop
{
// Ask the database for the information from the links table
$query1 = "SELECT first_name, posts, status, last_name, homepage, icq, aol, yahoo, email_address, username, password, avatar, signature, location, user_name, signup_date, last_login FROM users where username='$rows[6]'";
$result1 = mysql_query($query1);
// Now we print out the results, starting by making a table
while ($rowsuser = mysql_fetch_array($result1, MYSQL_ASSOC))

echo ("

<table cellpadding=0 cellspacing=0 border=0 bgcolor=#003493  width=100% align=center><tr><td>
<table cellpadding=4 cellspacing=1 border=0  width=100%>
<tr>
    <td bgcolor=#3E61A0 width=175 nowrap><font face=verdana,arial,helvetica size=1><b>Author</b></font></td>
    <td bgcolor=#3E61A0 width=100%>
    <table width=100% border=0 cellpadding=0 cellspacing=0>
    <tr>
        <td width=100%><font face=verdana,arial,helvetica size=1><b>Thread</b></font></td>
        <td><a href=index.php?action=threadn&board_id=$boardid>new thread</a></td>
        <td><font face=verdana, arial, helvetica size=2 >&nbsp;&nbsp;</font></td>
        <td>new reply</td>
    </tr>
    </table>
    </td>
</tr>
</table>
</td></tr></table>

<table cellpadding=0 cellspacing=0 border=0 bgcolor=#003493  width=100% align=center><tr><td>
<table cellpadding=4 cellspacing=1 border=0  width=100%>
<tr>
    <td bgcolor=#436BB5 width=175 valign=top nowrap>

    <font face=verdana, arial, helvetica size=2 ><b>$rows[6]</font><br>
    <img src=". $rowsuser['avatar'] ."><p>
<font color=#000000 size=1 face=Verdana, Arial, Helvetica, sans-serif>Status:". $rowsuser['status'] ."</font> 
</b></font>  <br>
        <font face=verdana,arial,helvetica size=1 >Location:". $rowsuser['location'] ."<br>
    Posts:". $rowsuser['posts'] ."</font></td>
    
    <td bgcolor=#436BB5 width=100% valign=top>
    <font face=verdana,arial,helvetica size=1 > <b>$rows[2]</b></font>
    <p><font face=verdana, arial, helvetica size=2 >$rows[3]</font></p>
    
    <p><p><font face=verdana, arial, helvetica size=2 >__________________<br>
". $rowsuser['signature'] ."

    </td>
</tr>
<tr>
    <td bgcolor=#436BB5 width=175 height=16 nowrap>$rows[8]</td>
    
    <td bgcolor=#436BB5 width=100% valign=middle height=16>
        <table width=100% border=0 cellpadding=0 cellspacing=0>
        <tr valign=bottom>
            <td><font face=verdana,arial,helvetica size=1 >
<a href=". $rowsuser['homepage'] ."><img src=../homepx.gif border=0></a>, find posts by user,
            &nbsp;&nbsp; icq status &nbsp;&nbsp; add to icq  &nbsp;&nbsp; <a href=aim:goim?screenname=". $rowsuser['aol'] ."&message=Hi.+Are+you+there><img src=../aim_icon.gif border=0></a> &nbsp;&nbsp; yahoo messager 
            </font></td>
            <td align=right nowrap><font face=verdana,arial,helvetica size=1 >
edit/delete
            </font></td>
        </tr>
        </table>
    </td>
</tr>
</table>
</td></tr>
");

}
// Finally we close off the table
echo "</table>";

?>

I used the script from http://www.devscripts.net/browse/93.php
and i want it to work when i load my data from $rows[3] and $rows[2] ive tried putting the code(html) like

PHP:

<?php

while ($rowsuser = mysql_fetch_array($result1, MYSQL_ASSOC))

$text = "........";

?>

and that works but only it doesnt load the rowsuser.

can anyone help me?
, im puzzled, again

___________________