ODBC Register Page - Last User Config.

This is my configuration and the name isn't displaying

Code:

---

<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?

Try this.

Code:

---

<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. :)

Thanks Linear . Requesting close.