[Paladine]

First hi to all, it's my first post

my problem is this:

i nedd to show the username and leveluser in the web, i try using the server behaviour in dw mx 2004 with the option dinamic text in a text box, but only shows the first register in the db, can any help me plz.


i'm using dw mx 2004, mysql and php last versions, running under apache in win xp.




PD: sorry for my bad english, i talh spanish

[NeverMind]

I think the query you are using has the : 'LIMIT 1' .. if so, just omit it ..

if not, please show your code so we can help..

[Paladine]

i don't find that, here is the code for show the data



<table width="200" border="0">
<tr>
<td>&nbsp;</td>
<td><form name="form1" method="post" action="">
<input name="textfield" type="text" value="<?php echo ucfirst($row_Recordset1['Nick']); ?>">
</form></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><form name="form2" method="post" action="">
<input name="textfield2" type="text" value="<?php echo ucfirst($row_Recordset1['Categoria']); ?>">
</form></td>


i hope that help

[blaw]

Hello there,

Hace tres anos que estudio espanol en mi escuela pero no puedo hablarla muy bien...

Anyways, I suppose $row_Recordset1 is an array that you fetched your query result into (e.g. something like $row_Recordset1 = mysql_fetch_assoc($result)). If so, you need to fetch as many times as you want - or until there is no more row to fetch.

You can loop through the result - while loop is a popular one for this particular purpose:

PHP Code:

<?php



// Assuming $result is the query result that contains more than one rows.



// While you can fetch the result's next row into this array...

while ($row_Recordset1 = mysql_fetch_assoc($result)) {

    // Your statements here.

    // For instance, if you wanted to show all "Nick" fields in a <td></td>, do this:

    echo '<td>'.$row_Recordset1['Nick'].'</td>';

}



?>

I see you are echoing the field values into textboxes, but the same logic applies here, too.

Hope this helps.

[Paladine]

but that will shows me all the "nicks" of the table or just the nick of the logged user?
because y need the logged user only

[blaw]

Oh that was fast. =)

The one I gave you above will show all the "Nick" s that have been returned from the database (i.e. whatever "Nick" s that the $result contains). So if your query is such that it returns all the logged-in users, yes, it will show all the logged-in users. But if not, then no.

Good luck.

[Paladine]

hehehe, i say the same when receive the email notification of reply


the proble is that i need to show to the user something like "welcome (nick), you are (categoria) in the web" , because there are restrcited areas according to the user level and i want the users know his own level

[dD|Fusion]

if i really got what you mean i think you should use some condicionals to make that...

PS: do you speak portuguese?


100+