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?
Re: ODBC Register Page - Last User Config.
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. :)
Re: ODBC Register Page - Last User Config.
Thanks Linear . Requesting close.