ODBC Register Page - Last User Config.

[iCreamPie]

This is my configuration and the name isn't displaying

<tr>
            <td align="center" class="Estilo7">Last User: <?

$query2 = odbc_exec($connect,"SELECT TOP 1 UserID FROM $accounttable WHERE USERID = '$Userid'");
$b = odbc_fetch_row($query2);
$aid = odbc_result($query2, 'Userid');

$name = $b[0];

echo "$name";

?></td>
          </tr>

Is that right , Am I missing something?

[MentaL]

[Linear88]

Try this.

<tr>
	<td align="center" class="Estilo7">Last User: 
<?php
$query2 = odbc_exec($connect, "SELECT TOP 1 UserID FROM Account(nolock) ORDER BY AID DESC");
odbc_fetch_row($query2);
$user = odbc_result($query2, 1);

echo $user;

?>
	</td>
</tr>

Click Thanks if it worked. :)

[iCreamPie]

Thanks Linear . Requesting close.