Ok, Gracias. De esta manera funciona, pero no deberia tener que hacerlo.

I'v problem with $xoopsDB->prefix() in a consult to DB with a subconsult.

Sorry for my english.

This's the sentence

$result = $xoopsDB->queryF("SELECT v_venta_nro FROM ".$xoopsDB->prefix("ventas")." WHERE id = (SELECT MAX(id) FROM ".$xoopsDB->prefix("ventas")." LIMIT 1 )ORDER BY id DESC") ;

$row = mysql_fetch_array($result);

esto es lo que buscaba

" $usuario = $xoopsUser->uname(); "

need get the 'uname' to filer fields of my database

Please, post information.

Gracias.
Ariel Ramone.
Argentina.

ok,
but not workQuote:

Please, I've problem making my module, this's a problem:

I need to filter external database for USUARIO, when 'User login' content in USUARIO show NNE, INE y Cantidad, but I'cant to use the 'login name' to filter my database.

This's a code :

<?php
# virtual('/Connections/Test.php'); ?>
#
<?php

#$colname_Recordset1 = "-1";
#if (isset($_POTS['uid'])) {
#$colname_Recordset1 = (get_magic_quotes_gpc()) ? #$_POST['uid'] : addslashes($_POST['uid']);
#}

#mysql_select_db($database_Test, $Test);
#$query_Recordset1 = sprintf("SELECT NNE, INE, CANTIDAD FROM #arsnreg WHERE USUARIO LIKE '%%%s%%' ORDER BY INE ASC", #$colname_Recordset1);
#$Recordset1 = mysql_query($query_Recordset1, $Test) or #die(mysql_error());
#$row_Recordset1 = mysql_fetch_assoc($Recordset1);
#$totalRows_Recordset1 = mysql_num_rows($Recordset1);
#?>
<?php
#include("../../mainfile.php");

#?>
<?php
#include(XOOPS_ROOT_PATH."/header.php"); ?>

<table border="1">
<tr>
<td width="122"><div align="center">NNE</div></td>
<td width="430"><div align="center">INE</div></td>
<td width="170"><div align="center">CANTIDAD</div></td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['NNE']; ?></td>
<td><?php echo $row_Recordset1['INE']; ?></td>
<td><?php echo $row_Recordset1['CANTIDAD']; ?></td>
</tr>
<?php } while ($row_Recordset1 = #mysql_fetch_assoc($Recordset1)); ?>
</table>
<?php
*/
#include(XOOPS_ROOT_PATH."/footer.php");

#mysql_free_result($Recordset1);
#?>

This's my firts module.
Gracias
Ariel Ramone
Argentina

[Moved from - Module hack reviews] Bluenova