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
